utton_Click()
>>>>> OriginalSheet.Activate
>>>>> Unload Me
>>>>> End Sub
>>>>>
>>>>> Private Sub cbPreview_Click()
>>>>> If cbPreview Then Sheets(ListBox1.Value).Activate
>>>>> End Sub
&
UserSheet.Visible = True
>> UserSheet.Activate
>> Else
>> OriginalSheet.Activate
>> End If
>> End If
>> Unload Me
>> End Sub
>>
>>
>>
>>
>> Thanks & Regards,
>> *
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
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:
Dear Sir,
Do we have a shortcut to know the number and name of the sheets in a
workbook and also list them in sequence.
Amit Kumar
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help, For
