LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #2   Report Post  
Ron de Bruin
 
Posts: n/a
Default

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



 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Copy Page Setup from Sheet to Sheet? blank Excel Discussion (Misc queries) 3 May 21st 05 10:23 AM
Is there a way to apply "page setup" defaults to an existing work. Excel default page set up formats Excel Discussion (Misc queries) 2 March 21st 05 10:54 PM
adding a new page break to an existing page break Edward Letendre Excel Discussion (Misc queries) 1 March 6th 05 09:29 AM
can you set the "Page Setup" margins etc. differently for each pag Tony Excel Worksheet Functions 4 February 2nd 05 01:15 PM
How do I copy page setup from one worksheet & paste into new shee. Rasc0 Excel Discussion (Misc queries) 2 December 1st 04 10:12 PM


All times are GMT +1. The time now is 12:54 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"