Hey!
I've got a protected spreadsheet that requires the user to input data in the unlocked cells.
Currently, I have an autofit code that works for the cell the user has input the data into: ActiveSheet.Columns.AutoFit
But it doesn't autofit the cell that displays the total of the cells (that the user does not input into).
How can I get the locked cell to also autofit?
Thanks!!
you'll need to unlock the cells too before doing the autofit so it changes all the columns
don't worry, there's a lot of people that are far more confused than you
but if you liked what i suggested. Click for me the "Add Reputation" - that way, we'd be both happy.
I tried that, but it still won't autofit the "totals" columns, it will only autofit the cells that data is keyed into.
can you post a copy of the workbook.. if possible.. just remove/replace the confidential data..
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks