Ivan
|
| posted on 26/7/18 at 07:50 AM |
|
|
Aaargh Excel - buttons won't print
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
|
| posted on 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
|
| posted on 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
|
| posted on 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
|
| posted on 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
|
| posted on 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
|
| posted on 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
Taller than your average Guy !
Management is like a tree of monkeys. - Those at the top look down and see a tree full of smiling faces. BUT Those at the bottom look up and see a
tree full of a*seholes .............
|
|
|
