Re: macro to save as

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

But i cant do that cos when im in Excel i cant see the menu bar with
Tools-Macros. So how do I get to edit the macro...cos i cant see the Tools
menu to get into the macro.

"Dave Peterson" wrote:

Try changing the False to True

and reexecuting that statement

Nazzy wrote:

Hi, I tried this, BUT how do i get the Menu Bar back, cos now i cant get it
back, please.

Thanks

"Bob Phillips" wrote:


Application.Commandbars("Worksheet Menu Bar").Enabled = False

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Mo" <Mo@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:BD4AFB5A-755E-4AA5-A068-405F2A6F90C4@xxxxxxxxxxxxxxxx
Bob,
Thanks for your help. I will give it a try.
I have one general question to ask. How or (can) do I hide the worksheet
menu bar. I tried View, Toolbars, Customize and unclick the menu bar.
But
it still defaulted to show the menu bar. My intention is to not allow the
user to delete, save as, or use other menus while in the work book. The
workbook is all driven by macros and there is no need for user to use or
"play" with the menu bar.

Thanks
Mo

"Bob Phillips" wrote:

You need to put it in a sub:-)

Sub SaveMyFile()
sFilename = Format(Worksheets("Sheet1").Range("A1").Value,
"yyyy-mm-dd")
ans = MsgBox ("Save file as " & sFilename)
if ans = vbOK Then
Activeworkbook.SaveAs Filename:= sFilename
End If
End Sub

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Mo" <Mo@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:1A7CCFBD-872C-4928-87CF-EB270BE2F3CE@xxxxxxxxxxxxxxxx
Bob,

I got an error message - "Complie Error, Invalid outside procedure"
it highlite the ("A1")

"Bob Phillips" wrote:

sFilename = Format(Worksheets("Sheet1").Range("A1").Value,
"yyyy-mm-dd")
ans = MsgBox ("Save file as " & sFilename)
if ans = vbOK Then
Activeworkbook.SaveAs Filename:= sFilename
End If

should do it

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Mo" <Mo@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:0EF07C3F-0542-4CF8-AECD-3C53B394F8AE@xxxxxxxxxxxxxxxx
I need to create a macro & assign it to a button. the macro needs
to
save
the current file based on a date that is entered in a cell. also
the
macro
needs to prompt the user to verify the filename(date) and then
save it
and
return to the current worksheet.

thanks

Mo










--

Dave Peterson

.

Relevant Pages

  • Re: Cant delete
    ... As you said TRK is highlighted in Status Bar. ... But surprisingly I cant turn it off as you said. ... But in this case whenever I try to erase I cannot erase. ...
    (microsoft.public.word.newusers)
  • Re: Missing menu bar, where could they have gone?
    ... My menu bar is missing on nautilus and terminal,. ... I cant remember what ...
    (Ubuntu)
  • Re: Missing menu bar, where could they have gone?
    ... My menu bar is missing on nautilus and terminal,. ... I cant remember what ...
    (Ubuntu)
  • Re: OT- Opera Help
    ... >Ok, I know, I'm a real twat when I did it, but was just messing around with the ... >various tools and panels, and now have removed my "address bar", so I cant enter ... >get my address bar back. ...
    (uk.rec.motorcycles)
  • Re: macro to save as
    ... I tried View, Toolbars, Customize and unclick the menu bar. ... >> (remove nothere from the email address if mailing direct) ... >>> Bob, ...
    (microsoft.public.excel.programming)