wow you consider learner m wondering what your expertise be :O
you all are rockstar here
thank you very very much for the help
I crave learning from you wonderful people. Thank you for takin time to
prepare the screen shot tuts
Regards,
Sunita
On Wed, Jul 11, 2012 at 2:53 PM, Deba Ranjan
Dear Sunita Ji,
After Alt + F11,
Go to View And Select Project Explorer,
Selcect Projects Windows too, it will help to change its Properties.
Select the desrie requirements in the Project Explorer, Double click the
desire objects, you will find the codes. And refer the before attached file.
Than
Sub listfiles()
For i = 1 To Sheets.Count
Cells(i, 1) = Sheets(i).Name
Next
End Sub
Don Guillett
Microsoft Excel Developer
SalesAid Software
dguille...@gmail.com
From: amitkmr
Sent: Tuesday, July 10, 2012 12:41 AM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ no of sheets in a wor
Thank you Noorain.
I hope can look at you if stuck in there.
Thank you once again.
Sunita
On Tue, Jul 10, 2012 at 5:05 PM, NOORAIN ANSARI wrote:
> Hi Sunita,
>
> Please find below link, hope it will you to explain "How can use Hotkey In
> VBA"
>
> http://www.excely.com/excel-vba/assign-hotkey-to-
Hi Sunita,
Please find below link, hope it will you to explain "How can use Hotkey In
VBA"
http://www.excely.com/excel-vba/assign-hotkey-to-smartdel-macro.shtml
http://www.mrexcel.com/archive/VBA/3401b.html
On Tue, Jul 10, 2012 at 4:22 PM, सुनिता पौडेल wrote:
> Dear all,
>
> This is very use
Dear all,
This is very useful information and I have been trying to use it at my
work. Since, I am in beginner phase can you please teach me as to how to do
it from the scratch?
Thank you all,
Sunita
On Tue, Jul 10, 2012 at 12:02 PM, NOORAIN ANSARI
wrote:
> Dear Amit,
>
> Try it..
>
>
> *Appli
Dear Amit,
Try it..
*Application.OnKey "%{+}", "short_key"
*
Sub short_key()
MsgBox Sheets.Count
End Sub
You can change combination
% for Alt
(^) for Ctrl
(+) for Shift
--
Thanks & regards,
Noorain Ansari
www.noorainansari.com
www.excelmacroworld.blogspot.com
On Tue, Jul 10, 2012 at 1
Dear Amit,
Please use this shortcut key: - Alt+A+A
Regards,
Kuldeep Singh
Phone.: +91-120-4763789, Extn.: 789
naukrikuld...@gmail.com || www.naukri.com
*Please* *Consider the environment. Please don't print this e-mail unless
you really need to.*
On Tue, Jul 10, 2012 at 11:11 AM, amitkmr wrote:
