Hi,
it would be great if we can get some more ( small ) tips about excel to make life easier.
Regards,
Discussion on:
View:
Show:
If you can supply some problems, I'll be glad to try to supply some solutions! Thanks!
It would be nice to have keystroke macros that worked properly as in Lotus 1-2-3 under dos. I don't particularly like having to debug Basic programmes for a simple keystroke macro.
Morning all
This is a variation on a pair of macros I use all the time. The issue is that I have a system which exports a lot of data on various organisations - one sheet per organisation. The sheet is then named with the name of the organisation, and there may be 100 or more sheets in a single workbook.
So, I have a macro called "Show All Sheets" which is virtually identical to the one above. But I also have one called "FindSheetByName" which prompts the user for a name, then searches for a sheet containing the provided text.
If anyone would find it useful, the code is on my website here:
http://www.theitservice.co.uk/tips-and-tricks/excel/locate_a_sheet_by_name.html
Regards
Andrew Richards
This is a variation on a pair of macros I use all the time. The issue is that I have a system which exports a lot of data on various organisations - one sheet per organisation. The sheet is then named with the name of the organisation, and there may be 100 or more sheets in a single workbook.
So, I have a macro called "Show All Sheets" which is virtually identical to the one above. But I also have one called "FindSheetByName" which prompts the user for a name, then searches for a sheet containing the provided text.
If anyone would find it useful, the code is on my website here:
http://www.theitservice.co.uk/tips-and-tricks/excel/locate_a_sheet_by_name.html
Regards
Andrew Richards
Or, use ASAP Utilities and select "Unhide All Sheets" from the menu. Most Excel users should have this anyway.
Hello,
My philosophy is that if you don't want to to deal with hassles later on, you should not select to hide your spreadsheets in the first place. However, some people might like to keep some of their data secret but I'm sometimes a bit lazy so I came up with the solution that if you don't choose the hide option in Excel, you'll not have to bother with making it appear again the next time you use the program.
My philosophy is that if you don't want to to deal with hassles later on, you should not select to hide your spreadsheets in the first place. However, some people might like to keep some of their data secret but I'm sometimes a bit lazy so I came up with the solution that if you don't choose the hide option in Excel, you'll not have to bother with making it appear again the next time you use the program.
I don't agree. I have a couple of applications written in Excel VBA and I hide sheets for two reasons:
First: There are sheets that contain control and status information that has nothing to do with the users and would only tempt them to try to change settings (the sheets are protected but this is not the issue).
Second: Depending on the status of the application and what is being done at the time, some sheets are relevant and some are not. The irrelevant ones are hidden to make it easier for the user to find what he/she needs quickly and without confusion.
First: There are sheets that contain control and status information that has nothing to do with the users and would only tempt them to try to change settings (the sheets are protected but this is not the issue).
Second: Depending on the status of the application and what is being done at the time, some sheets are relevant and some are not. The irrelevant ones are hidden to make it easier for the user to find what he/she needs quickly and without confusion.
- Keyboard Shortcuts:
- Prev
- Next
- Toggle
