Unactivating
Does anyone know a way to have a sheet with no selection and no cell
activated? A simple function, not a side effect of locking, protecting, baying at the moon, or any of that. Merely be able to say something like 'Sheets("my_sheet").Deactivate' or whatever and end up with no ActiveCell and no Selection? -- Terry "I said I never had much use for one, I never said I didn't know how to use one." M. Quigley |
Unactivating
Hi Terry:
No. Regards, Vasant. "Terry von Gease" wrote in message ... Does anyone know a way to have a sheet with no selection and no cell activated? A simple function, not a side effect of locking, protecting, baying at the moon, or any of that. Merely be able to say something like 'Sheets("my_sheet").Deactivate' or whatever and end up with no ActiveCell and no Selection? -- Terry "I said I never had much use for one, I never said I didn't know how to use one." M. Quigley |
Unactivating
In VBA no problem. Just .Activate another sheet.
If this isn't exactly what you want (ie. there may be cells selected in the sheet to come back to) Range("A1").Select will get you back to the minimum possible. NB. ActiveCell is a child of the Application Object. "Terry von Gease" wrote in message ... Does anyone know a way to have a sheet with no selection and no cell activated? A simple function, not a side effect of locking, protecting, baying at the moon, or any of that. Merely be able to say something like 'Sheets("my_sheet").Deactivate' or whatever and end up with no ActiveCell and no Selection? Regards BrianB ======================================= |
Unactivating
To use cells as buttons while protecting their contents without dealing with
any of excel's inelegant and annoying error messages about changing the contents of locked cells. In other words to have a cell that has it's contents locked silently. Buttons themselves are rather clumsy bulky things, okay for a couple or three but more than that rapidly becomes a pain in the ass for alignment and sizing as well as being visually repulsive. While I could easily select some editable cell upon selection of the cell acting as button there is a bit of a problem with this on a sheet that has no unprotected cells, no place to go. Another method, probably the one I will end up having to use, would be to set the format of the button cell to some constant value, for example set the format to """sort"";""sort"";""sort"";""sort""" then not only trap selection events for this cell to invoke whatever it is I want to invoke but also trap changes to the cell and simply clear it out every time someone attempts to enter anything in it. There's problems with this as well. -- Terry "I said I never had much use for one, I never said I didn't know how to use one." M. Quigley "Bob Phillips" wrote in message ... I'm intrigued. Why would you want to? -- HTH Bob Phillips "Vasant Nanavati" wrote in message ... Hi Terry: No. Regards, Vasant. "Terry von Gease" wrote in message ... Does anyone know a way to have a sheet with no selection and no cell activated? A simple function, not a side effect of locking, protecting, baying at the moon, or any of that. Merely be able to say something like 'Sheets("my_sheet").Deactivate' or whatever and end up with no ActiveCell and no Selection? -- Terry "I said I never had much use for one, I never said I didn't know how to use one." M. Quigley |
All times are GMT +1. The time now is 03:58 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com