Disabling Page Setup?
 

Hi, I'm fairly new to Excel and was wondering how one might be able to
Disable the Page Setup menu in Excel? Any suggestions would be
appreciated. Thank you.


--
Plazzma
------------------------------------------------------------------------
Plazzma's Profile: http://www.excelforum.com/member.php...o&userid=25234
View this thread: http://www.excelforum.com/showthread...hreadid=387228

Hi

Sub test()
Application.CommandBars("Worksheet Menu Bar").FindControl _
(ID:=247, Recursive:=True).Enabled = False
End Sub

You must also disable printpreview
See for more info
http://www.rondebruin.com/menuid.htm


--
Regards Ron de Bruin
http://www.rondebruin.nl


"Plazzma" wrote in message
...

Hi, I'm fairly new to Excel and was wondering how one might be able to
Disable the Page Setup menu in Excel? Any suggestions would be
appreciated. Thank you.


--
Plazzma
------------------------------------------------------------------------
Plazzma's Profile: http://www.excelforum.com/member.php...o&userid=25234
View this thread: http://www.excelforum.com/showthread...hreadid=387228