Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Using macro to un/protect sheet
hi hi, thx agen for the previous helps =D
i searched this up to see if i could find nething b4 disturbing you nice ppl lol, but i still dont understand. i want to make a button, which will allow the user to View the books n not rewrite. And a button which allows the user to actually add/edit the data, however this user would need to enter a password. i want both buttons to open the same workbook, but each with a different authority. I dont know how to create like a message or box where the user has to enter a password to gain access in adding new data . i've been thinkin long and hard but dont know where to start, can anyone help me out? lol thanks in advance =) |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
macro to find cell content in sheets and make sheet active | Excel Discussion (Misc queries) | |||
Macro to Go to Sheet | Excel Discussion (Misc queries) | |||
Macro that password protects a sheet | Excel Discussion (Misc queries) | |||
MACRO - copy rows based on value in column to another sheet | Excel Discussion (Misc queries) | |||
2 questions, copying data from sheet to sheet and assigning macro | Excel Worksheet Functions |