• Status: Solved
  • Priority: Medium
  • Security: Private
  • Views: 46
  • Last Modified:

Put a big label on an Excel spreadsheet.

Hi,

I need to put a big label on top of an Excel spreadsheet which is no longer being used to let people know.

Please advise how to do that.

Thanks.
0
nav2567
Asked:
nav2567
4 Solutions
 
JohnBusiness Consultant (Owner)Commented:
Put a password on the Excel file and keep a record of the password. That is what I would do.
0
 
nav2567Author Commented:
No.  I want to put a big label going across of a spreadsheet.  For example, "This spreadsheet has been decommissioned.  Please do not use"
0
 
JohnBusiness Consultant (Owner)Commented:
You have to open the spreadsheet to see the label, so once open, people will use it even if you tell them no.

For the label, make big (large font, say 24 point) text in a cell and colour it Yellow). Make that A1.   That creates your label that you want.
0
Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

 
Rob HensonFinance AnalystCommented:
Remove it to an archive folder so that it cannot be accessed.
0
 
Rob HensonFinance AnalystCommented:
If you still want it visible, insert a blank sheet into the file and then hide all other sheets. Put a big text box on that blank sheet with the message. If that sheet is only sheet visible the file will open on that sheet.

In Windows Explorer, mark it as Read Only so that if someone does open it they can't do anything with it unless they save a copy.

You could also put the message in the filename so that people know before they open the file.
0
 
Martin LissOlder than dirtCommented:
Try this. I just added a shape and formatted it in Worksheet_Open. If you need help with it let me know.
29094984.xlsm
0
 
Roy CoxGroup Finance ManagerCommented:
Here's another suggestion.

Hide data behind a UserForm. Macros must be enabled
HidebehindUserForm.xlsm
0
 
Rob HensonFinance AnalystCommented:
No response from Author
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now