VBA to disable or hide buttons on Print Preview

CapsHockey · Mar 21st, 2002, 10:38 AM

I'm looking for a way to hide the buttons such as Setup, Margins, etc on the Print Preview toolbar through VB/VBA code. I'm not sure what object to reference.

Tom Schreiner · Mar 22nd, 2002, 01:02 AM

Hi I'm not sure if you can do that at all??
You can, however, prevent the user from making changes like this:

sheet1.pagesetup.printpreview = false

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

Mar 21st, 2002, 10:38 AM	#1
CapsHockey New Member Join Date: Feb 2002 Posts: 5	I'm looking for a way to hide the buttons such as Setup, Margins, etc on the Print Preview toolbar through VB/VBA code. I'm not sure what object to reference.

Mar 22nd, 2002, 01:02 AM	#2
Tom Schreiner Board Regular Join Date: Mar 2002 Location: Cincinnati, Ohio, USA Posts: 6,824	Hi I'm not sure if you can do that at all?? You can, however, prevent the user from making changes like this: sheet1.pagesetup.printpreview = false