Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Ctrl-v doesn't work after changing Application.DisplayFormulaBar
I am developing a spreadsheet based tool. When this
workbook is active in Excel I hide the FormulaBar and StatusBar (by setting Application.DisplayStatusBar=false, APplication.DisplayFormulaBar=false in Workbook_Activate). When the user leaves the workbook I redisplay the formula and status bars. So I have: Workbook_Activate() Application.DisplayStatusBar=false Application.DisplayFormulaBar=false exit sub Workbook_Deactivate() Application.DisplayStatusBar=true Application.DisplayFormulaBar=true exit sub If I copy a cell in the workbook I am developing and then move to another workbook I cannot paste that cell. Neither Ctrl-v nor Edit-Paste work. Excel doesn't seem to see the clipboard contents but the cell I copied IS in the clipboard because I can see it when I look at the Clipboard toolbar in Excel. If I comment out the lines Application.DisplayStatusBar=true Application.DisplayFormulaBar=true then copy and paste works as normal. These commands seem to be confusing Excel's knowledge of the clipboard. Has anyone else encountered this problem? Is there a work- around???? Many thanks Lee |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Ctrl-v doesn't work after changing Application.DisplayFormulaBar
Works the same way in xl2002, too.
The only work around I have is to not hide them. You could drop them completely or check application.cutcopymode before you toggle things. Option Explicit Sub Workbook_Activate() If Application.CutCopyMode = False Then Application.DisplayStatusBar = False Application.DisplayFormulaBar = False End If End Sub Lee Drage wrote: I am developing a spreadsheet based tool. When this workbook is active in Excel I hide the FormulaBar and StatusBar (by setting Application.DisplayStatusBar=false, APplication.DisplayFormulaBar=false in Workbook_Activate). When the user leaves the workbook I redisplay the formula and status bars. So I have: Workbook_Activate() Application.DisplayStatusBar=false Application.DisplayFormulaBar=false exit sub Workbook_Deactivate() Application.DisplayStatusBar=true Application.DisplayFormulaBar=true exit sub If I copy a cell in the workbook I am developing and then move to another workbook I cannot paste that cell. Neither Ctrl-v nor Edit-Paste work. Excel doesn't seem to see the clipboard contents but the cell I copied IS in the clipboard because I can see it when I look at the Clipboard toolbar in Excel. If I comment out the lines Application.DisplayStatusBar=true Application.DisplayFormulaBar=true then copy and paste works as normal. These commands seem to be confusing Excel's knowledge of the clipboard. Has anyone else encountered this problem? Is there a work- around???? Many thanks Lee -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to make Ctrl-C, ctrl-V work in Office 2007 | Excel Discussion (Misc queries) | |||
CTRL+F doesn't work | Excel Discussion (Misc queries) | |||
CTRL X...CTRL V...Why does it NOT work? | Excel Discussion (Misc queries) | |||
I can't get the Undo to work even using ctrl z | Setting up and Configuration of Excel | |||
DisplayFormulaBar = True | Excel Programming |