Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Setting up Excel (2003) to handle users with different editing abilities
I would greatly appreciate it if one could give me some code to start me
off as I'm fairly new to macroing. I want to set a spreadsheet up so that the first thing they get after opening it is a prompt to enter a password which I'll set and control. There are 2 editors of this spreadsheet and each has their own columns to update. If user1 enters password "abcd" into the popup window, the spreadsheet sets up so that they can insert new rows but cannot enter anything into Col D and Col E. If user2 enters password "efgh" into the popup window, the spreadsheet sets up so that they can insert/create new rows but cannot enter anything into Cols A:C. Is this relatively easy to do? Thanks, Alan |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Setting all users to save Excel 2007 files in 2003 format | Excel Discussion (Misc queries) | |||
disable users from editing an excel sheet once they open | Excel Discussion (Misc queries) | |||
Setting Fill Handle Defaults | Excel Discussion (Misc queries) | |||
Excel 2003 Context menu handle | Excel Discussion (Misc queries) | |||
Hide cell formula without losing formatting abilities | Excel Worksheet Functions |