Excel Help - Saxperience

Harv · 24th April 2008, 17:26

Right, I'm trying to print my coursework off atm. Thing is though, it won't seem to print command buttons that have macro's linked to them. Quite annoying as I need them to print.

Screen shot of page:

On Print Preview:

See the buttons on the bottom have gone

. Starting to piss me off this lol. Anyone know how to do it?

Rep will be given if i can
Harv

vidal · 24th April 2008, 17:29

Do a screengrab?

V.

Harv · 24th April 2008, 17:35

Quote:

Originally Posted by vidal

Do a screengrab?

V.

Good point, what like a print screen onto photoshop or something. Then just print it out as normal. Hmmm.....why the hell didnt I think of that

Harv · 24th April 2008, 17:45

Hmmm....dosen't really work as it goes all blurred. I can't get it big enough without using print preview to take a screenshot of.

Anyone know how to print these things?

GreenSaxo · 24th April 2008, 21:19

you need to set the print area.

highlight the cells you want to print.. then file. set print area

Harv · 25th April 2008, 00:02

Quote:

Originally Posted by GreenSaxo

you need to set the print area.

highlight the cells you want to print.. then file. set print area

Yea....did that mate and still didn't work though. Found out how to do it a while ago though. Just had to right click on the command buttons and turn on 'print object' as its default is off.

I hate coursework so much, think I'm going to be up all night lol.

Thanks any mate