(Msg. 1) Posted: Tue Jul 22, 2008 8:01 am
Post subject: Edit commands not available Add to elertz Archived from groups: microsoft>public>excel>crashesgpfs (more info?)
I have Excel 2003, SP3 on a laptop. For some time now, the "Cut" "Copy"
"Paste" "Paste Special" commands that I use often are grayed out (not
available). How do I solve this problem?
(Msg. 2) Posted: Tue Jul 22, 2008 10:42 pm
Post subject: RE: Edit commands not available Add to elertz [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
Can you do a few checks?
1) Tools->Protection->Unproctect(worksheet & workbook)
2) Making sure the workbook is not shared (Tools, Share Workbook..., remove
checkmark from allow multiple users)
3) If that doesnt work, could you plz try this ?
a) Open Excel
b) Press Alt+F11 (to open the vbe)
c) Insert -> Module (enter the lines below in the module)
Sub EnableTB()
With CommandBars(1).Controls("Edit")
.Controls("Copy").Enabled = True
.Controls("Paste").Enabled = True
.Controls("Paste Special...").Enabled = True
End With
End Sub
Press F5 to execute the code. (Make sure the curson is placed in the
procedure )
HTH,
--
Tausif Mohammed
"Eric Young" wrote:
> I have Excel 2003, SP3 on a laptop. For some time now, the "Cut" "Copy"
> "Paste" "Paste Special" commands that I use often are grayed out (not
> available). How do I solve this problem?
(Msg. 3) Posted: Wed Jul 23, 2008 6:28 am
Post subject: RE: Edit commands not available Add to elertz [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
1. The Tools, Protection command was gray.
2. The Tools, Share Workbook command was gray.
3. After selecting Insert Module in Microsoft Visual Basic, I entered the
commands exactly as shown below. When executing the routine with the F5
command I received
Run-time error "5":
Invalid procedure call or argument
I chose "Debug" and it highlighted the "Paste Special" line. I did not find
anything entered differently than shown below.
What next?
"Tausif" wrote:
> Can you do a few checks?
>
> 1) Tools->Protection->Unproctect(worksheet & workbook)
> 2) Making sure the workbook is not shared (Tools, Share Workbook..., remove
> checkmark from allow multiple users)
>
> 3) If that doesnt work, could you plz try this ?
> a) Open Excel
> b) Press Alt+F11 (to open the vbe)
> c) Insert -> Module (enter the lines below in the module)
> Sub EnableTB()
> With CommandBars(1).Controls("Edit")
> .Controls("Copy").Enabled = True
> .Controls("Paste").Enabled = True
> .Controls("Paste Special...").Enabled = True
> End With
> End Sub
> Press F5 to execute the code. (Make sure the curson is placed in the
> procedure )
>
> HTH,
> --
> Tausif Mohammed
>
>
> "Eric Young" wrote:
>
> > I have Excel 2003, SP3 on a laptop. For some time now, the "Cut" "Copy"
> > "Paste" "Paste Special" commands that I use often are grayed out (not
> > available). How do I solve this problem?
(Msg. 4) Posted: Wed Jul 23, 2008 10:45 pm
Post subject: RE: Edit commands not available Add to elertz [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
Hi Eric,
The line shld be ".Controls("Paste Special...").Enabled = True "
I just tried it out, it worked fine for me. Are you using Excel 2003 ?
Atleast is the Copy & Paste command working for you now ?
Cheers,
--
Tausif Mohammed
"Eric Young" wrote:
> 1. The Tools, Protection command was gray.
> 2. The Tools, Share Workbook command was gray.
> 3. After selecting Insert Module in Microsoft Visual Basic, I entered the
> commands exactly as shown below. When executing the routine with the F5
> command I received
>
> Run-time error "5":
> Invalid procedure call or argument
>
> I chose "Debug" and it highlighted the "Paste Special" line. I did not find
> anything entered differently than shown below.
>
> What next?
>
> "Tausif" wrote:
>
> > Can you do a few checks?
> >
> > 1) Tools->Protection->Unproctect(worksheet & workbook)
> > 2) Making sure the workbook is not shared (Tools, Share Workbook..., remove
> > checkmark from allow multiple users)
> >
> > 3) If that doesnt work, could you plz try this ?
> > a) Open Excel
> > b) Press Alt+F11 (to open the vbe)
> > c) Insert -> Module (enter the lines below in the module)
> > Sub EnableTB()
> > With CommandBars(1).Controls("Edit")
> > .Controls("Copy").Enabled = True
> > .Controls("Paste").Enabled = True
> > .Controls("Paste Special...").Enabled = True
> > End With
> > End Sub
> > Press F5 to execute the code. (Make sure the curson is placed in the
> > procedure )
> >
> > HTH,
> > --
> > Tausif Mohammed
> >
> >
> > "Eric Young" wrote:
> >
> > > I have Excel 2003, SP3 on a laptop. For some time now, the "Cut" "Copy"
> > > "Paste" "Paste Special" commands that I use often are grayed out (not
> > > available). How do I solve this problem?
(Msg. 5) Posted: Fri Jul 25, 2008 3:05 pm
Post subject: RE: Edit commands not available Add to elertz [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
It seems I can now copy & paste, but not paste special. A survey of all the
menu commands that are gray returns the following:
File - Save, Save as, Save as Web Page, Save Workspace, Sent to, Properties.
Edit - Can't Repeat, Cut, Paste Special, Paste as Hyperlink, Delete Sheet,
Move or Copy Sheet, Links, Object.
Insert - Worksheet.
Tools - Compare & Merge Worksheet, Protection, Macro.
Data - Refresh Data.
Window - Compare Side by Side With, Unhide
The Version is Excel 2003 (11.8211.8202) SP3
Thanks for your interest.
"Tausif" wrote:
> Hi Eric,
>
> The line shld be ".Controls("Paste Special...").Enabled = True "
> I just tried it out, it worked fine for me. Are you using Excel 2003 ?
>
> Atleast is the Copy & Paste command working for you now ?
>
> Cheers,
> --
> Tausif Mohammed
>
>
> "Eric Young" wrote:
>
> > 1. The Tools, Protection command was gray.
> > 2. The Tools, Share Workbook command was gray.
> > 3. After selecting Insert Module in Microsoft Visual Basic, I entered the
> > commands exactly as shown below. When executing the routine with the F5
> > command I received
> >
> > Run-time error "5":
> > Invalid procedure call or argument
> >
> > I chose "Debug" and it highlighted the "Paste Special" line. I did not find
> > anything entered differently than shown below.
> >
> > What next?
> >
> > "Tausif" wrote:
> >
> > > Can you do a few checks?
> > >
> > > 1) Tools->Protection->Unproctect(worksheet & workbook)
> > > 2) Making sure the workbook is not shared (Tools, Share Workbook..., remove
> > > checkmark from allow multiple users)
> > >
> > > 3) If that doesnt work, could you plz try this ?
> > > a) Open Excel
> > > b) Press Alt+F11 (to open the vbe)
> > > c) Insert -> Module (enter the lines below in the module)
> > > Sub EnableTB()
> > > With CommandBars(1).Controls("Edit")
> > > .Controls("Copy").Enabled = True
> > > .Controls("Paste").Enabled = True
> > > .Controls("Paste Special...").Enabled = True
> > > End With
> > > End Sub
> > > Press F5 to execute the code. (Make sure the curson is placed in the
> > > procedure )
> > >
> > > HTH,
> > > --
> > > Tausif Mohammed
> > >
> > >
> > > "Eric Young" wrote:
> > >
> > > > I have Excel 2003, SP3 on a laptop. For some time now, the "Cut" "Copy"
> > > > "Paste" "Paste Special" commands that I use often are grayed out (not
> > > > available). How do I solve this problem?
All times are: Eastern Time (US & Canada) (change)
Page 1 of 1
You can post new topics in this forum You can reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum
Home
Forums
Home
FAQ
Search
Profile
Private Messages
Log in/Register/Password
Office