| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Is there any way to access the formula bar through VBA code?
Greetings,
When I protect my excel sheet, I am no longer able to see the contents of the cells in the formula bar even for the cells which are not locked. Is there any way to achieve this in Excel 2000? Can I write a code in some event where I can copy the text from the currently selected cell to the formula bar? Thanks. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Is there any way to access the formula bar through VBA code?
This isn't usual behavior.
Unlocked cells on protected sheets should still show up in the formula bar. I'd double check that lockedness and hiddeness of that cell. nilangini wrote: Greetings, When I protect my excel sheet, I am no longer able to see the contents of the cells in the formula bar even for the cells which are not locked. Is there any way to achieve this in Excel 2000? Can I write a code in some event where I can copy the text from the currently selected cell to the formula bar? Thanks. -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Using Access in Excel VB Code | Excel Discussion (Misc queries) | |||
| VBA Code to query Access DB | Excel Programming | |||
| how to access macro code | Excel Programming | |||
| Is there somewhere I can access Excel-VB code at once? | Excel Programming | |||
| Where to put code for access by all workbooks | Excel Programming | |||
Hybrid Mode
