Make a sheet in a workbook a template

[GoodmanJim]

How to you make a sheet in a workbook a template? I want the sheet to remain constant while I insert data and when reuse the sheet in the original condition.

 

[Jeffrey Mahoney]

Well, You should probably protect the sheet so that users can't alter stuff you don't want them to. First thing is to identify which cells that need to be locked (not editable), and lock them using Home-Format-Format Cells-Protection Tab (Ctrl-1). When you protect the sheet, you get to choose which type of items you want users to change and have the option of protecting it with a password.

Now you need to find a way to put the information in a database and then clear out the editable values for the next go round. Macros are the best bet.

Excel doesn't have a quick and easy 123 method of creating a template.

We need some information to begin. Buckle up and bring some snacks, this is going to take awhile.

 

[GoodmanJim]

Thanks Jeffrey

I think I was not descripting my problem correctly. I have a worksheet in a workbook that has 112 activeX control buttons on this worksheet. When I move about this worksheet, I move the buttons by accident. I want to lock the activeX control buttons in their position, so I cannot move them, while putting data in other cells.

 

[Jeffrey Mahoney]

That is a different story

 

[Jeffrey Mahoney]

Buttons do that to me also. They also shrink and grow. Have you tried protecting your sheet? If you have the lock status to TRUE in the Button Properties, they should remain constant.

 

[Jeffrey Mahoney]

Sometimes I create cells that look like buttons and use sheet events to run macros. The only thing is that you have to double-click cell buttons to trigger them.

 

[GoodmanJim]

Sometimes I create cells that look like buttons and use sheet events to run macros. The only thing is that you have to double-click cell buttons to trigger them.

Thanks again
JIm