Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Protection
I've made about 70 workbooks all saved as the specific product they hold
information on. Each workbook has 4 sheets. Sheet 1 is where new data is entered. Sheet 2 lists the new data entered each time we enter it and just moves the older data down one row. Sheet 3 is our Certificate of Analysis which is very important and muct not be altered. Sheet 4 is a graph of the data entered for each parameter. The First macro I use inserts a new row on sheet 2 so that the new data can be added and all excisting data is shifted down. Private Sub CommandButton1_Click() Sheets("Sheet2").Select Selection.Insert Shift:=xlDown Sheets("Sheet1").Select End Sub The Second macro I use allows me to alter information on Sheet 1 and then transfers that information to the correct location on sheets 2,3, and 4. example: ''''''''''''''''''''Transfers Data From Sheet 1 To Sheet 2 And 3'''''''''''''''''''' '''''''''''''''''''''''''''''''''''''''''''''''''' '''''''''''''''''''''''''''''''''' Sheets("Sheet1").Select Range("B1").Select Selection.Copy Sheets("Sheet2").Select ' Product Name Range("E1").Select ActiveSheet.Paste Sheets("Sheet3").Select Range("B10").Select ActiveSheet.Paste Is it possible to Protect EVERY cell except a few select ones on sheet 1 where data is entered so that once you enter and engage the macro you cannot go to sheet 2,3, or 4 and change anything? The problems I am having are when I protect every sheet except the select cells on sheet1 and I engage the first macro it will not shift the rows down on sheet2 because sheet 2 is protected. The other problem is since I am transfering data from sheet1 to the other 3 sheets it wont transfer the data to protected sheets. sorry for rambling. I just want to be the only person able to alter all the information of each workbook. I do however want other people to have the ability to open my workbook. Enter new data into the allocated cells ( cells B5 - B8 and B11 - B17) and engage the 2 macros transfering the data to sheets 2,3, and 4 while not giving them the ability to change any of the other information on sheet 1 or the other 3 sheets. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel Data Protection Best Practice: AKA: Real Sheet Protection | Excel Discussion (Misc queries) | |||
Excel Data Protection- AKA: Sheet/Macro Password Protection | Setting up and Configuration of Excel | |||
WS Protection: Different Levels of Protection on Different Ranges | Excel Discussion (Misc queries) | |||
Cell Protection vs. Worksheet Protection | Excel Discussion (Misc queries) | |||
Worksheet protection is gone and only wokbook protection can be se | Excel Discussion (Misc queries) |