Hi
I am using Excel 2000 and have a spreadsheet that contains information which I do not want printing how do I stop other users from doing this?
thanks
Hi
I am using Excel 2000 and have a spreadsheet that contains information which I do not want printing how do I stop other users from doing this?
thanks
Last edited by VBA Noob; 04-10-2009 at 11:27 AM.
You could put a Cancel in the Before_Print event of that workbook (to reside in ThisWorkbook object)
Though obviously they could just copy the data to another workbook and/or not enable macros in the first instance... ie it is not as simple as the above as it can be circumvented relatively easily...Please Login or Register to view this content.
Of course there's the old tried & trusted: ask them not to print given confidential info.
My Recommended Reading:
Volatility
Sumproduct & Arrays
Pivot Intro
Email from XL - VBA & Outlook VBA
Function Dictionary & Function Translations
Dynamic Named Ranges
Here i have a trick to stop users to print work sheet .......
Suppose you have data in Sheet1
1. Now copy the Data from Sheet1
2. Go in Sheet2. Press Shift > Edit > Paste Picture Link
3. Now your sheet1 will be pasted in Sheet2. Any change in Sheet1 will be automatically changed.
4. Now in Sheet2, select Pic & Format > Picture > Properties and Uncheck Print Object. & don't move or size with cells.
5. Now protect the worksheet by un-checking all boxes of sheet protection. Your sheet2 will be appear on screen but no one can print it thru excel.
6. Now hide sheet1 thru VBA windows -> Properties.
Note : you can not stop anyone to print as they can take use print screen option.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks