GallowayJay
New Member
- Joined
- Apr 8, 2002
- Messages
- 15
Hello!
I want to be able to automatically add rows to a particular sheet. My ultimate goal is to have an individual enter the number of rows they desire. Then the sheet would provide the amount of row space requested. I intend to protect the sheet from unauthorized adjustments, but in order to satisfy the row requirement, I need some macro (or function) in place. The Alt-Insert-Rows will not work in a protected sheet. Therefore, I need an alternative. Any ideas from the gurus of this board?
I want to be able to automatically add rows to a particular sheet. My ultimate goal is to have an individual enter the number of rows they desire. Then the sheet would provide the amount of row space requested. I intend to protect the sheet from unauthorized adjustments, but in order to satisfy the row requirement, I need some macro (or function) in place. The Alt-Insert-Rows will not work in a protected sheet. Therefore, I need an alternative. Any ideas from the gurus of this board?