Solved

in excel I want to hide the same colums

Posted on 2011-02-13
9
278 Views
Last Modified: 2012-05-11
I keep on pullng down spreadsheets, three or 4 of them they are tasks I need to complete.

Usually they have too much information in them.  keep on going in and hiding the same cells every time I open up the boss's copy on the sharepoint.

Is there a way to hide the same colums each time I open the sheet ?  I would like to apply the changes after I open up the sheet


I can not alter the bosses copy with the hiding. :)  
0
Comment
Question by:TIMFOX123
  • 4
  • 2
  • 2
  • +1
9 Comments
 
LVL 20

Assisted Solution

by:pari123
pari123 earned 125 total points
ID: 34883372
record a macro to hide the cells when you first open your boss's copy. everytime you open the file, just run the macro and it will take care of the rest. :)
0
 
LVL 20

Expert Comment

by:pari123
ID: 34883601
if u can give us specific columns to hide and the exact requirements, i can create something for you...
0
 
LVL 41

Assisted Solution

by:dlmille
dlmille earned 375 total points
ID: 34883803
Sub HideBossColumns()

'this function called on open of boss workbook

columns("A:G").entirecolumn.hidden = true 'change this to be the columns you want to hide

end sub
0
 
LVL 59

Expert Comment

by:Chris Bottomley
ID: 34885864
How would you identify one of your bosses workbooks?

Chris
0
Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

 
LVL 41

Assisted Solution

by:dlmille
dlmille earned 375 total points
ID: 34889663
You can also embed the macro in your boss's spreadsheet the first time he creates it, and put the HideBossColumns() routine I put forward in it, and also this

'Put this in ThisWorkbook codepage the first time you get your boss's workbook
Private Sub Workbook_BeforeClose(Cancel As Boolean)
    Call UnhideBossColumns
End Sub
Private Sub Workbook_Open()
    If Environ("Username") = "my name" Then
        Call HideBossColumns
    End If
End Sub

'Put these in a MODULE codepage
Sub UnhideBossColumns()
    Columns("A:G").EntireColumn.Hidden = False
End Sub
Sub HideBossColumns()
    Columns("A:G").EntireColumn.Hidden = True
End Sub

However, its probably pretty easy to visually know you want to hide boss columns, and just run the macro from your personal.xls or something.

Dave
0
 

Author Comment

by:TIMFOX123
ID: 34903071
I am working on this but I have a very big priority in my job right now sooo...

I may try to make a sheet and paste in the bosses stuff in it.

run a macro to make a "veiw"

what do you think.  Is there a easy way to take the data an nothing else. ?

You all have been grand!!
0
 
LVL 41

Expert Comment

by:dlmille
ID: 34903353
It would be easier to hide the columns - but, you're the judge and have to live with the solution!

Good Luck!

Dave
0
 
LVL 41

Accepted Solution

by:
dlmille earned 375 total points
ID: 34903354
PS - I guess you can copy his sheet to your workbook and do Edit->Paste Special->Values - that will get the data and no formulas...

Dave
0
 

Author Closing Comment

by:TIMFOX123
ID: 34919011
thank you all.  

I had a whole army of help.
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Vb.net dynamic formulas in runtime 11 61
Hard coding time and date into Excel 2 28
Excel macro runs twice 13 40
Error in formula not increasing value 2 0
In case Office 2010 has not been deployed in your environment, this article may be quite useful. In our office, we wanted a way to deploy Microsoft Office Professional Plus 2010 through an automated batch file via logon script. This article is docum…
Freeze panes is an option within all variants of Excel to enable parts of a sheet to remain stationary when the cursor is in another part of the sheet. This is a very useful feature which is overlooked or under used.
This Micro Tutorial will demonstrate how to use a scrolling table in Microsoft Excel using the INDEX function.
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

943 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

16 Experts available now in Live!

Get 1:1 Help Now