I have an issue in Excel 2010 workbook. The workbook has multiple columns that are always hidden, however when I click in a cell to enter a formula (in an already-unhidden column), the hidden columns automatically unhide and they do not re-hide when I am finished with the formula.
Any suggestions to help troubleshoot this issue are much appreciated!
Can you upload the sheet with confidential info removed? It sounds like there's a macro unhiding those sheets. Does your workbook employ macros? It would most likely be an event driven VBA located in the sheet code rather than in a module. (Right click on the sheet tab and "View Code")
ChemistB
My 2?
substitute commas with semi-colons if your region settings requires
Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)
Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble
Thank you for the response!
There are no macros and no code when I 'view code'. The spreadsheet is doing it on my boss's computer but not mine - even though they are the same versions. He does not utilize Excel beyond basic formulas - no macros or anything like that. I can't seem to replicate the issue on my PC and any forums I find on the subject have no answers
Could be that, on your bosses computer, the spreadsheet is loaded from a "trusted" area/folder, or that macros have been enabled. Your computer might have your macro security set up differently,for example, always block macros without asking.
If you can't see the code, it may be that the VBA Project is locked for viewing.
Best bet is to upload the workbook with any confidential data removed.
Regards, TMS
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
Here is the file. A formula entered in any cell on the FDATA tab results in all columns in that tab being unhidden. Thanks so much for your help! We are stumped!Copy of KONA_FDATA_model2.xls
Give an example cell, i can put say =a1 in say ff86 and nothing happens untoward
"Unless otherwise stated all my comments are directed at OP"
Mojito connoisseur and now happily retired
where does code go ?
look here
how to insert code
how to enter array formula
why use -- in sumproduct
recommended reading
wiki Mojito
how to say no convincingly
most important thing you need
Martin Wilson: SPV
and RSMBC
does your boss have any of the lotus compatibility options checked in excel options at the bottom of the advanced section?
Josie
if at first you don't succeed try doing it the way your wife told you to
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks