locking and editing tables

[twallis]

Hello

Is it possible to set tables as a template in a spreadsheet so that you cannot change or delete the table size or style but still able to input data?

Regards

 

[Splith]

More information would be helpful such as what kind of table is it? What version are you using? and of course if you could provide a sample or at least detail the variables just to give us an idea of what we are dealing with.

But to provide my best answer to that would be to say.
protect the sheet and give no allowence other than selecting unprotected cells. This will also protect against format changes.

 

[Splith]

sorry more incomplete info. Make sure that all of the variable information is unprotected so it can be selected by a user. Again keep your axis protected

 

[twallis]

ah fantastic, i'm sure that will help. my knowledge is sketchy where I can do some complicated things but am not aware of some simple functions so your reply is appreciated.

thanks again

 

[Splith]

No Problem. Share the knowledge.