xlfan2007
08-11-2011, 09:47 PM
Hello All,
This site has been of a great resource for rookies like me..
My new probelm is something like this...
I use Tabel feature(Ctrl+T) in Excel 2007 with recurring data entry and is shared with many on a network.
My table has formulae which are not to be modified, but unknowingly many of my coleagues modify them without any/my knowledge ruining the purpose of automisation.Please help me with a setup of coding for.....(representative file attached)
In the SETUP tab of my attachment, if I check the checkbox in A representing the fields listed in B
The Table ranges of the table in the SALES tab should be locked with no access to modify.
for this sheet, value & grand total ranges must be locked with formulae.I tried to protect the sheet, which disallowed me or my friends to expand for further data entry.
Also, I need the SETUP tab to be locked and accessed only with a password for customisation.Kindly, source the code for setuping on various other workbooks relating to my work.
Thank you!
:help :help
This site has been of a great resource for rookies like me..
My new probelm is something like this...
I use Tabel feature(Ctrl+T) in Excel 2007 with recurring data entry and is shared with many on a network.
My table has formulae which are not to be modified, but unknowingly many of my coleagues modify them without any/my knowledge ruining the purpose of automisation.Please help me with a setup of coding for.....(representative file attached)
In the SETUP tab of my attachment, if I check the checkbox in A representing the fields listed in B
The Table ranges of the table in the SALES tab should be locked with no access to modify.
for this sheet, value & grand total ranges must be locked with formulae.I tried to protect the sheet, which disallowed me or my friends to expand for further data entry.
Also, I need the SETUP tab to be locked and accessed only with a password for customisation.Kindly, source the code for setuping on various other workbooks relating to my work.
Thank you!
:help :help