First off I have developed a workaround to this I just want to know why it happens!!
I have a time and attendance Workbook. It is used in 20 facilities some on a LAN some stand alone. On some machines the column width shrinks a little each time the program opens and the buttons shrink and shift left. This continues until the sheet is unreadable.
To work around I deleted all the buttons and wrote a build on the fly menu system. This acually speeds up the code like 90% so this is good. Other code checks the column width agaist what I want it to be and if any column is not standard the column width then all columns are reset. This happens just once. This code resets when you change sheets.
I have been on several forums and have heard others complain about the same problem. I would like to find out why it happens so that I can set an on open event to stop users from doing what ever it is that causes the problem to begin with. (if this is at all posible)
Yours in EXCELelent Frustration
Brian.
I have a time and attendance Workbook. It is used in 20 facilities some on a LAN some stand alone. On some machines the column width shrinks a little each time the program opens and the buttons shrink and shift left. This continues until the sheet is unreadable.
To work around I deleted all the buttons and wrote a build on the fly menu system. This acually speeds up the code like 90% so this is good. Other code checks the column width agaist what I want it to be and if any column is not standard the column width then all columns are reset. This happens just once. This code resets when you change sheets.
I have been on several forums and have heard others complain about the same problem. I would like to find out why it happens so that I can set an on open event to stop users from doing what ever it is that causes the problem to begin with. (if this is at all posible)
Yours in EXCELelent Frustration
Brian.