Hi,
Can anyone advise a way of restricting an excel file using VBA (or some other method) from printing all bar one specific sheet?
As others have relatively sensitive information on I wouldnt want the users to accidently print the wrong sheets.
Thanks,
Adam
Last edited by Ad83; 02-29-2012 at 11:33 AM.
The following would need to be worked to your criteria regarding which sheet should be printed. Place the following in ThisWorkbook module
Please Login or Register to view this content.
If you're happy with someone's help, click that little star at the bottom left of their post to give them Reps.
---Keep on Coding in the Free World---
This should be enough
Please Login or Register to view this content.
Hope that helps.
RoyUK
--------
For Excel Tips & Solutions, free examples and tutorials why not check out my web site
Free DataBaseForm example
Roy,
Would you not need to account for multiple worksheets being grouped and printed?
Dom
"May the fleas of a thousand camels infest the crotch of the person who screws up your day and may their arms be too short to scratch..."
Use code tags when posting your VBA code: [code] Your code here [/code]
Remember, saying thanks only takes a second or two. Click the little star to give some Rep if you think an answer deserves it.
I always use code similar to what I posted. I think it will stop printing of grouped sheets.
It is pointless whatever, because if macros aren't enable then the users can print anything.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks