Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
show locked cells
I need to be able to show which cells are unlocked and in which users of this
spreadsheet can enter data via a light shade in the locked cells, but I don't want this shade to print. I found a few posts talking about this sort of thing, but I don't know how to use the code given. Any pointers on applying code or using Visual Basic would be awesome. I'm an intern and need some brownie points, so help me out! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
show locked cells
Hi Stephen,
Any pointers on applying code or using Visual Basic would be awesome. I'm an intern and need some brownie points, so help me out! you may wish to visit David McRitchie's 'Getting Started With Macros And User Defined Functions' at: http://www.mvps.org/dmcritchie/excel/getstarted.htm You might also look at David's tutorials page at: http://www.mvps.org/dmcritchie/excel....htm#tutorials --- Regards, Norman "Stephen" wrote in message ... I need to be able to show which cells are unlocked and in which users of this spreadsheet can enter data via a light shade in the locked cells, but I don't want this shade to print. I found a few posts talking about this sort of thing, but I don't know how to use the code given. Any pointers on applying code or using Visual Basic would be awesome. I'm an intern and need some brownie points, so help me out! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Locked Cells Sorting | Excel Discussion (Misc queries) | |||
Excel locked cells | Excel Discussion (Misc queries) | |||
unlocked cells in excel 2000 now locked when opened in 2003 why? | Excel Discussion (Misc queries) | |||
All Cells in Excel are locked, what's wrong? | Excel Discussion (Misc queries) | |||
Viewing LOCKED cells | Excel Discussion (Misc queries) |