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.
Bookmarks