Results 1 to 8 of 8

Thread: Unable to set the visible property of the worksheet class

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. 05-17-2012, 10:30 AM #2
    princ_wns
    princ_wns is offline
    Member
    Join Date
    Nov 2011
    Posts
    41
    Rep Power
    0
    Hi excelfun,

    you can use a single line of code for hidding the sheet ie,

    Code:
    ThisWorkbook.Sheets("Sheet1").Visible = false
    regards


    https://www.youtube.com/channel/UCnxwq2aGJRbjOo_MO54oaHA
    https://www.youtube.com/watch?v=f7xZivqLZxc&lc=Ugxq4JHRza_zx3sz0fx4AaABAg
    https://www.youtube.com/watch?v=f7xZivqLZxc&lc=UgzMCQUIQgrbec400jl4AaABAg
    https://www.youtube.com/watch?v=f7xZivqLZxc&lc=UgwhVTFaD469mW9wO194AaABAg. 9gJzxwFcnPU9gORqKw5tW_
    https://www.youtube.com/watch?v=f7xZivqLZxc&lc=Ugyb8nmKKoXvcdM58gV4AaABAg
    https://www.youtube.com/watch?v=f7xZivqLZxc&lc=UgwvvXcl1oa79xS7BAV4AaABAg
    https://www.youtube.com/watch?v=f7xZivqLZxc&lc=UgxvIFArksPprylHXYZ4AaABAg
    https://www.youtube.com/watch?v=f7xZivqLZxc&lc=Ugxq4JHRza_zx3sz0fx4AaABAg
    https://www.youtube.com/channel/UCnxwq2aGJRbjOo_MO54oaHA
    Last edited by DocAElstein; 07-11-2023 at 01:05 PM. Reason: code tag added
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Similar Threads

  1. Make cells visible based on Data Validation criteria
    By IJC in forum Excel Help
    Replies: 4
    Last Post: 05-05-2013, 04:01 AM
  2. Unable to Get ElementID In VBA IE Automation
    By ashu1990 in forum Excel Help
    Replies: 9
    Last Post: 03-28-2013, 11:58 AM
  3. Print Nth Worksheet To Mth Worksheet using VBA
    By Ryan_Bernal in forum Excel Help
    Replies: 2
    Last Post: 02-28-2013, 06:57 PM
  4. Replacement for the Flawed UsedRange Property
    By Rick Rothstein in forum Rick Rothstein's Corner
    Replies: 9
    Last Post: 12-04-2012, 08:09 PM
  5. Using property ColorScaleCriteria color you cells
    By Rasm in forum Download Center
    Replies: 0
    Last Post: 12-04-2011, 09:20 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules