Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Locking formatting
- Thread starter pbellc
- Start date
AFAIK, you can only do this in XP
You need to go Tools>Protection>Allow users to edit ranges
Select all cells but DON'T enter a password
Then, protect the sheet - making sure that the option to allow changes in formatting is NOT ticked
The users should now be able to enter data but not change the column widths or row heights
Rgds, Geoff
Quantum materiae materietur marmota monax si marmota monax materiam possit materiari?
Want the best answers to your questions ? faq222-2244
You need to go Tools>Protection>Allow users to edit ranges
Select all cells but DON'T enter a password
Then, protect the sheet - making sure that the option to allow changes in formatting is NOT ticked
The users should now be able to enter data but not change the column widths or row heights
Rgds, Geoff
Quantum materiae materietur marmota monax si marmota monax materiam possit materiari?
Want the best answers to your questions ? faq222-2244
If you dont necessarily need to see which row or column you are in, you could remove the Row & Column Headers completely.
1. Go to Tools->Options...
2. Open the View Tab
3. Uncheck Row & column headers
4. Press OK
Please note that this setting in on the worksheet level and you will have to change it for each worksheet in a workbook that you don't want the users to change the row and column sizes.
Any user who knows about this setting can turn it off by going the same route as before so you might want to find out how to disable the Tools->Options... menu selection for that specific workbook. This can be done in VBA.
If you can't be "The Best", be the best at what you can!!!
Never say Never!!!
Nothing is impossible!!!
1. Go to Tools->Options...
2. Open the View Tab
3. Uncheck Row & column headers
4. Press OK
Please note that this setting in on the worksheet level and you will have to change it for each worksheet in a workbook that you don't want the users to change the row and column sizes.
Any user who knows about this setting can turn it off by going the same route as before so you might want to find out how to disable the Tools->Options... menu selection for that specific workbook. This can be done in VBA.
If you can't be "The Best", be the best at what you can!!!
Never say Never!!!
Nothing is impossible!!!
- Status
Similar threads
