Solved

in excel I want to hide the same colums

Posted on 2011-02-13
9
282 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 4
  • 2
  • 2
  • +1
9 Comments
 
LVL 20

Assisted Solution

by:Ardhendu Sarangi
Ardhendu Sarangi 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:Ardhendu Sarangi
ID: 34883601
if u can give us specific columns to hide and the exact requirements, i can create something for you...
0
 
LVL 42

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
Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
LVL 59

Expert Comment

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

Chris
0
 
LVL 42

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 42

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 42

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

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

This article will show you how to use shortcut menus in the Access run-time environment.
How to get Spreadsheet Compare 2016 working with the 64 bit version of Office 2016
Learn how to create and modify your own paragraph styles in Microsoft Word. This can be helpful when wanting to make consistently referenced styles throughout a document or template.
Many functions in Excel can make decisions. The most simple of these is the IF function: it returns a value depending on whether a condition you describe is true or false. Once you get the hang of using the IF function, you will find it easier to us…

749 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