Swoop_GB

The project I'm working on has a bit of code in the workbook open event that makes excel go full screen, hide any toolbars that a user has configured to run in fullscreen (and make a note so they can be restored on exit) and loads a custom toolbar. [code] …

Is there a simple way to list all the toolbars a user currently has visible? I'm trying to hide everything on screen appart from my worksheet, including the file menu. I've found a way to do it (custom toolbar, hide everything else) but need to be able to restore the …

Here's the problem. I'm designing a worksheet for very young children and what they need to do is type a number into a cell and then click a button to run the macro. However, in order to click this button they first must either press ENTER or TAB or click …

I need to be able to check if another user has an excel workbook open (from a network drive) from within another workbook. user 1 has workbook1 open and has a macro to open workbook2, paste some data in, save it and close it, I need to add code to …

[COLOR="Red"]DISREGARD[/COLOR] EDIT: found an answer. -------------------------------------------------------------------------------------------- Trying to unprotect a protected worksheet, write to a cell and protect it again. The following code works ok if the workbook is [B][U][I]not[/I][/U][/B] shared: [CODE] ActiveSheet.Unprotect Range("D18").Value = 1 ActiveSheet.Protect DrawingObjects:=True, Contents:=True, Scenarios:=True [/CODE] However, when the workbook is shared for network use …