Disable page setup!

stone · May 19th, 2002, 08:21 AM

Hi guys.

Is there any way for me to disable the File-> Page setup button?

BK
Stulli

Mark O'Brien · May 19th, 2002, 09:01 AM

you can do this using VBA:



  Application.CommandBars("Worksheet Menu Bar").Controls("&File").Controls("Page Set&up...").Enabled = False

You need to remember to set it back to being enabled before exiting the worksheet:



  Application.CommandBars("Worksheet Menu Bar").Controls("&File").Controls("Page Set&up...").Enabled = True

stone · May 19th, 2002, 09:37 AM

Thanx Mark.

BK
Stulli

May 19th, 2002, 09:01 AM	#2
Mark O'Brien MrExcel MVP Join Date: Feb 2002 Location: Columbus, OH, USA Posts: 3,519	you can do this using VBA: Application.CommandBars("Worksheet Menu Bar").Controls("&File").Controls("Page Set&up...").Enabled = False You need to remember to set it back to being enabled before exiting the worksheet: Application.CommandBars("Worksheet Menu Bar").Controls("&File").Controls("Page Set&up...").Enabled = True __________________ Mark O'Brien Columbus Ohio Celtic Supporters Club

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

May 19th, 2002, 08:21 AM	#1
stone Board Regular Join Date: Apr 2002 Location: iceland Posts: 138	Hi guys. Is there any way for me to disable the File-> Page setup button? BK Stulli

May 19th, 2002, 09:37 AM	#3
stone Board Regular Join Date: Apr 2002 Location: iceland Posts: 138	Thanx Mark. BK Stulli