Disable ALL Instances of Page Setup

[DaddyDave]

Hello again guys....

Is there a way to disable ALL instances of Page Setup? I have three... (I hope ONLY three...)

One in the right click menu, one in the File menu, and one in the right click menu of the little Excel icon beside the File menu.

I can get the first two to disable... but not the latter...

As always, your help will be appreciated......

Dave

 

[tactps]

I only have one. Do you know where the last 2 you mentioned came from?

Rather than go down this path, you can always add a:
Private Sub Workbook_BeforePrint(Cancel As Boolean)
event to change the page setup to what you want (ie override whatever the user has done to change it).