Disable page setup!

[stone]

Hi guys.

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

BK
Stulli

 

[Mark O'Brien]

you can do this using VBA:

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

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

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

 

[stone]

Thanx Mark.

BK
Stulli