hiding and unhiding

I've written a handful of VBA and I always get caught up on when to use certain terminology, more specifically when it comes to hiding/unhiding. I've found that sometimes the correct method is to use something.visible = true / something.visible = false and other times I have to write...

I was wondering if anyone knows how to hide the formula bar and ribbon in vba? Thanks, -J

I use a variety of spreadsheets at my office, and I may have figured this out already, but I wanted to get other people's ideas for maybe a fresh look at something... I am working on a spreadsheet where I want the recipients to see the results of the data in a table showing average discounted...

Hi I don't know if its possible, but what i am trying to do is give different people different passwords for a work book. So; Person 1 - would see sheet 1 and sheet 2 Person 2 - would see sheet 1 and sheet 3 Person 3 - would see sheet 1 and sheet 4 The idea behind this is sheet 1 would act as...

Hi, I have this code in my module Private Sub Boys_Click()If Boys.Value = True Then Rows("13:57").EntireRow.Hidden = True Else Rows("13:57").EntireRow.Hidden = False End If End Sub However, my problem is whenever i protect the sheet it doesnt allow me to proceed(debug mode) since i am...

Hi there, First time posting to the forum, so take it easy on me, alrighty? I'm working on a workbook with multiple tabs. I am trying to make one of these tabs (called Services) and particularly dynamic one. In this case, I have values in cells b15, b16, and b17. If b15 has a value of 1+...