[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 691
  • Last Modified:

excel column unhide function does not work

excel column unhide function does not work.  It worked the last time I used this workbook.  It is not protected.
0
dparrot
Asked:
dparrot
1 Solution
 
redrumkevCommented:
dparrot,

which column is not "unhiding" if it is A, try this:
http://www.experts-exchange.com/Software/Office_Productivity/Office_Suites/MS_Office/Excel/Q_23903942.html
Code attached below. If are unfamilar with macros, go to the link above, it explains how to insert a new module and then execute it.

Hope this helps,
Kevin

sub unhidea()
activesheet.range("A1").columnwidth = 15
end sub

Open in new window

0

Featured Post

Veeam and MySQL: How to Perform Backup & Recovery

MySQL and the MariaDB variant are among the most used databases in Linux environments, and many critical applications support their data on them. Watch this recorded webinar to find out how Veeam Backup & Replication allows you to get consistent backups of MySQL databases.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now