thank you
On Mon, Feb 27, 2012 at 5:57 PM, NOORAIN ANSARI wrote:
> http://www.mrexcel.com/forum/showthread.php?t=354
>
> On Mon, Feb 27, 2012 at 5:00 PM, Shankar Bheema wrote:
>
>> is it possible to save a particular worksheet of a workbook with a save
>> command button on an userform ?
>>
>> --
http://www.mrexcel.com/forum/showthread.php?t=354
On Mon, Feb 27, 2012 at 5:00 PM, Shankar Bheema wrote:
> is it possible to save a particular worksheet of a workbook with a save
> command button on an userform ?
>
> --
> FORUM RULES (986+ members already BANNED for violation)
>
> 1) Use concise
For workbook -
ActiveWorkbook.Save
For active sheet only -
ActiveSheet.Select
ActiveSheet.Copy
ActiveSheet.SaveAs Filename:="YOUR DIR" & YOUR FILENAME & ".xls"
HTH
Abhishek
On Mon, Feb 27, 2012 at 5:00 PM, Shankar Bheema wrote:
> is it possible to save a particular worksheet of a workbook w
