i use alt f8, 'select sheets' to print my worksheets. my shortcut key is 'ctrl P'. Can i create a button to automate this? thank you Brian
i use alt f8, 'select sheets' to print my worksheets. my shortcut key is 'ctrl P'. Can i create a button to automate this? thank you Brian
Brian
select sheets is a macro?
So add code in the macro to print whatever sheets you want printed, and assign a keyboard shortcut.![]()
Entia non sunt multiplicanda sine necessitate
that's what i do now. i'm trying to put the code in a button that will pull up the select sheets form when i click it. I'm using a Control Toolbox command button. the code i'm trying to use is 'run.[module1]'. but it doesn't work. i would appreciate your help w/ the code.
How much faster is it to push a button than to do Ctrl+P?
Make a button from the Forms toolbar or an autoshape and assign the macro.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks