MENU / COMMAND BARS

matthewh · May 24th, 2002, 02:04 AM

I have a workbook that I need to stop users 'playing' with - you know the sort of thing. I can hide the menu and command bars, but different users around the country use different command bars. Can I script it so that Xl gets interogated to find which are visible and hide them , restoring only the ones they had to start with when it closes? I got moaned at cos one guy suddenly got a formatting bar I use but he doesn't.

Ivan F Moala · May 24th, 2002, 02:35 AM

Quote:

On 2002-05-24 01:04, matthewh wrote:
I have a workbook that I need to stop users 'playing' with - you know the sort of thing. I can hide the menu and command bars, but different users around the country use different command bars. Can I script it so that Xl gets interogated to find which are visible and hide them , restoring only the ones they had to start with when it closes? I got moaned at cos one guy suddenly got a formatting bar I use but he doesn't.

What you will have to do is Loop through the
commandbars and store there Visble property
in a Static array, then when closing just loop through the array and rest the commandbars.....

Have a look here for useful info on commandbars.

http://msdn.microsoft.com/library/techart/ofcmdbar.htm

http://support.microsoft.com/support.../Q166/7/55.ASP

http://w1.2735.telia.com/~u273500023/english/index.htm

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

May 24th, 2002, 02:04 AM	#1
matthewh New Member Join Date: Mar 2002 Posts: 34	I have a workbook that I need to stop users 'playing' with - you know the sort of thing. I can hide the menu and command bars, but different users around the country use different command bars. Can I script it so that Xl gets interogated to find which are visible and hide them , restoring only the ones they had to start with when it closes? I got moaned at cos one guy suddenly got a formatting bar I use but he doesn't.