ws.visible

Hi All Can someone please help with my issue. Basically I have a workbook that has a Template tab, Home Page tab, Reports tab plus mutiple project tabs with different names. On the Home Page tab I have a search box where I will enter a project tab name to search it in the open tabs. The code...

Hi Friends, I am stuck with one thing in a User form . I have a dropdown where the data is taking from a sheet. I want only unique values in the droplist. I already have the code , but can someone please help me to edit this code which will give only unique values in the droplist. Note ...

I would like to loop thru the work book and hide all sheets except a given list. Below are two macros I wrote, neither works. Can anyone tweak one or the other? Sub Macro1() For Each sh In ActiveWorkbook.Worksheets Select Case sh.Name Case Is = "Summary", "Sheet1", "Assa Abloy...

Hi Could someone help me with these 2 lines in red; Dim ws As Worksheet If CheckBox1 = True Then If ws.Name Like "*3CT*" Then ws.Visible = xlSheetVisible End If ElseIf CheckBox2 = True Then If ws.Name Like "*3CT*" Then...

I am getting a run-time error '1004' Method 'Visible' of object'_Worksheet' failed when running a macro. I have to have the workbook protected to keep users from deleting sheets. The code works great when the workbook is unprotected. I had to change it workbook_deactivate instead of...

I am a novice VBA user. I have a menu page with different cells that all hyperlink to hidden sheets. All sheets unhide except a few that give me the "Run Time error 9 - Subscript out of range". Where is my error? Thank you for looking! Below is a pic of the debug (Error is in RED) line and...