Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Command Bar
I tried to set up a file that allows different users to only view a section
of the file. In order to protect some data, I tried to use the following macro to disable the command bar. Sub disable dim bar as commandbar for each bar in application.commandbars bar.enabled = false next end sub I also use the same code to enable the commandbars before close. However, when I open a new excel, nothing happen when I right click on anywhere in the cell. I tried several ways but can not get it back. If I run the same code, I can get it back. But after i close the file, same problem will happen when I reopen the file. I really need to borrow your knowledge here. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
command code ( GOTO command) in formula | New Users to Excel | |||
Userform Command Button not available until another command buttonhas been used | Excel Programming | |||
Pivot Table Error Message - "Command Text not set for command obje | Excel Discussion (Misc queries) | |||
Wanting to Create A Command Button Command | Excel Programming | |||
Excel to load COMMAND and type a Run Command? | Excel Programming |