Board logo

Aaargh Excel - buttons won't print
Ivan - 26/7/18 at 07:50 AM

I have a workbook with a website masque I am developing with lots of VBA buttons. I want to print it but the buttons won't print. If you right click on each button, select "Format Control/Properties and tick Print Object " it will print. My problem is I cannot find a way to tick all the boxes in one go and don't want the agro of doing 10's of buttons individually - have tried googling for answer with no luck.

Anyone with an easy answer and a way to make the "print object" box ticked by default when adding buttons?

I have tried importing the screens into Word but for some unknown reasons it comes in all peculiar like with the table formatting messed up.

Could do it as images but then the file is too big for passing around. In South Africa we can't put Gov files on non-SA cloud services like Dropbox and the Gov. cloud services can't be accessed by private individuals.

Aaaaargh

nick205 - 26/7/18 at 09:29 AM

Not sure on Excel, but on MS Word 2010 for example there's a tool that refreshes all inserted fields (e.g. filename, date etc.).

A search on Google oftens throws up some answers or at least forums with relevant discussions.

Ivan - 26/7/18 at 09:45 AM

OK I have found a partial solution - Control right click on all buttons on a page to select them all then set the Format Control for all of the selected buttons in one go. At least I only have to do it 20 times instead of many more times.

Mr Whippy - 26/7/18 at 11:53 AM

assuming your buttons are just shapes then you just hold down Ctrl and select them all, then right click to bring up properties and those setting will apply to all the buttons at the same time

Can't think any other way that Excel lets you do it


[Edited on 26/7/18 by Mr Whippy]

David Jenkins - 26/7/18 at 02:00 PM

quote:
Originally posted by Mr Whippy
assuming your buttons are just shapes then you just hold down Ctrl and select them all, then right click to bring up properties and those setting will apply to all the buttons at the same time



No personal experience of this in Excel - but can you do Ctrl-A? i.e. select all.

Mr Whippy - 27/7/18 at 06:14 AM

quote:
Originally posted by David Jenkins
quote:
Originally posted by Mr Whippy
assuming your buttons are just shapes then you just hold down Ctrl and select them all, then right click to bring up properties and those setting will apply to all the buttons at the same time



No personal experience of this in Excel - but can you do Ctrl-A? i.e. select all.


Nice one, yip that works very well, didn't know that one myself. Seems to auto select clusters of numbers too, always learning...

Agriv8 - 27/7/18 at 07:13 AM

Microsoft snipping tool usually get me out of problems like this.

Its usually hidden away somewhere in the OS ( depending on your Versions )

type snipping in the search above start button and see if it there !

ATB Agriv8