Logo 
Search:

MS Office Answers

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds
  Question Asked By: George Evans   on Oct 18 In MS Office Category.

  
Question Answered By: Vidos Fischer   on Oct 18

You have Excel 97? I'm pretty sure that version  had sheet  hiding on the
menu, although I don't currently have a version I can run, to check.

Format / Sheet / (Un)Hide is where it would be. For some reason, it's not
available in the right-click options on the tabs at the bottom.

Excel 97 was a big step forward from Excel 95, and the 2000, XP and 2003
versions were just minor improvements. (I haven't tried 2007.)

AFAIK there is no explicit way of checking the Excel version from VBA. (At
one stage, I think I used a cheat to work out if I was on 97, rather than
2000, but I don't remember the details, and don't seem to have the code any
more. I think I finally dropped the version-specific code and simply wrote
my own versions of the functions involved.)

Share: 

 

This Question has 8 more answer(s). View Complete Question Thread

 
Didn't find what you were looking for? Find more on Is it possible to detect Excel version? Or get search suggestion and latest updates.


Tagged: