?
Solved

in excel I want to hide the same colums

Posted on 2011-02-13
9
Medium Priority
?
285 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 500 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 1500 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
What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

 
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 1500 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 1500 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

Office 365 Training for Admins - 7 Day Trial

Learn how to provision tenants, synchronize on-premise Active Directory, implement Single Sign-On, customize Office deployment, and protect your organization with eDiscovery and DLP policies.  Only from Platform Scholar.

Question has a verified solution.

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

When you see single cell contains number and text, and you have to get any date out of it seems like cracking our heads.
This article describes a serious pitfall that can happen when deleting shapes using VBA.
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

764 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