when speardsheet is saved then reopened later a command button is over the push button
What …!?
when a push button is inserted and then the sheet is saved and closed then reopened the button is now hidden under a command button.
I simply don’t know the term “Command Button” for something selectable from a Form Control toolbar.
In what way does your “command button” or the visible presentation of it differ from the Push Button you inserted?
Best attach a sample .ods
.
I think the problem is I converted an excel spreadsheet into a ods.
I tried a new spreadsheet and never had a problem.
I’m going to try and copy just the data into a new and see if that works.
thanks for the input
That seems to be the problem. I copied all the data into a new spreadsheet and added a push button then saved and closed and reopened where everything was working.
A command button is a control in visual basic so the old formatting must have still remained. I guess
thanks again