Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old December 13th 05, 07:26 PM posted to microsoft.public.excel.setup
DTTODGG
 
Posts: n/a
Default Disallow "SAVE" only "SAVE AS" or prompt

Hello-

I have built a form using excel. I have protected all cells except user
inputs.

I'm wondering if there is a way to force the user to either exit without
saving or use "save as". I guess that sort a makes this file a template.

Either way, I would appreciate your wisdom on how to solve this dilema.

I have only poked around with macros and vba so be very specific.
Thank you kindly

  #2   Report Post  
Old December 13th 05, 07:33 PM posted to microsoft.public.excel.setup
DTTODGG
 
Posts: n/a
Default Disallow "SAVE" only "SAVE AS" or prompt

OK, so a template does work!
Sorry to waste bit bucket space.

So many questions, so little time!

"DTTODGG" wrote:

Hello-

I have built a form using excel. I have protected all cells except user
inputs.

I'm wondering if there is a way to force the user to either exit without
saving or use "save as". I guess that sort a makes this file a template.

Either way, I would appreciate your wisdom on how to solve this dilema.

I have only poked around with macros and vba so be very specific.
Thank you kindly

  #3   Report Post  
Old December 13th 05, 07:44 PM posted to microsoft.public.excel.setup
DTTODGG
 
Posts: n/a
Default Disallow "SAVE" only "SAVE AS" or prompt

OK - I want to be a bit fancier now.

I have a template. I would like to force the file to be saved by the name it
a cell (J2). So, when they want to save the file, they just click on save or
save as, the template prompts them for a name, the name is already filled in
as the name in cell J2, they just confirm it.

Thank you for teaching me a lot and making me look good!

"DTTODGG" wrote:

Hello-

I have built a form using excel. I have protected all cells except user
inputs.

I'm wondering if there is a way to force the user to either exit without
saving or use "save as". I guess that sort a makes this file a template.

Either way, I would appreciate your wisdom on how to solve this dilema.

I have only poked around with macros and vba so be very specific.
Thank you kindly

  #4   Report Post  
Old December 14th 05, 10:39 AM posted to microsoft.public.excel.setup
Bob Phillips
 
Posts: n/a
Default Disallow "SAVE" only "SAVE AS" or prompt

Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As
Boolean)
Application.EnableEvents = False
Cancel = True
ThisWorkbook.SaveAs Worksheets("Sheet1").Range("J2").Value
Application.EnableEvents = True

End Sub


'This is workbook event code.
'To input this code, right click on the Excel icon on the worksheet
'(or next to the File menu if you maximise your workbooks),
'select View Code from the menu, and paste the code



--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"DTTODGG" wrote in message
...
OK - I want to be a bit fancier now.

I have a template. I would like to force the file to be saved by the name

it
a cell (J2). So, when they want to save the file, they just click on save

or
save as, the template prompts them for a name, the name is already filled

in
as the name in cell J2, they just confirm it.

Thank you for teaching me a lot and making me look good!

"DTTODGG" wrote:

Hello-

I have built a form using excel. I have protected all cells except user
inputs.

I'm wondering if there is a way to force the user to either exit without
saving or use "save as". I guess that sort a makes this file a template.

Either way, I would appreciate your wisdom on how to solve this dilema.

I have only poked around with macros and vba so be very specific.
Thank you kindly



  #5   Report Post  
Old December 15th 05, 02:03 PM posted to microsoft.public.excel.setup
DTTODGG
 
Posts: n/a
Default Disallow "SAVE" only "SAVE AS" or prompt

Bob, Thank you so much!

Can you help me specify the directory to save this file in?

In addition, if I save in "C:/MyForms/Range"J2".xls" what happens if the
directory doesn't exist? Will it prompt to make a directory?

Cheers!
P.S. I picked up O'Reilly's book on macros - so maybe there's hope I'll
learn this stuff. A lot of my problems are syntax - how to you name an
external file you want to open, how you specify cells in other workbooks or
worksheets. But I'm learning.

"Bob Phillips" wrote:

Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As
Boolean)
Application.EnableEvents = False
Cancel = True
ThisWorkbook.SaveAs Worksheets("Sheet1").Range("J2").Value
Application.EnableEvents = True

End Sub


'This is workbook event code.
'To input this code, right click on the Excel icon on the worksheet
'(or next to the File menu if you maximise your workbooks),
'select View Code from the menu, and paste the code



--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"DTTODGG" wrote in message
...
OK - I want to be a bit fancier now.

I have a template. I would like to force the file to be saved by the name

it
a cell (J2). So, when they want to save the file, they just click on save

or
save as, the template prompts them for a name, the name is already filled

in
as the name in cell J2, they just confirm it.

Thank you for teaching me a lot and making me look good!

"DTTODGG" wrote:

Hello-

I have built a form using excel. I have protected all cells except user
inputs.

I'm wondering if there is a way to force the user to either exit without
saving or use "save as". I guess that sort a makes this file a template.

Either way, I would appreciate your wisdom on how to solve this dilema.

I have only poked around with macros and vba so be very specific.
Thank you kindly






  #6   Report Post  
Old December 19th 05, 09:54 PM posted to microsoft.public.excel.setup
Marc
 
Posts: n/a
Default Disallow "SAVE" only "SAVE AS" or prompt

Well, why don't you just make the file read only? Then the only way to save
is "save as"...


  #7   Report Post  
Old December 21st 05, 04:54 PM posted to microsoft.public.excel.setup
DTTODGG
 
Posts: n/a
Default Disallow "SAVE" only "SAVE AS" or prompt

Thank you, Marc -

But, as long as I already have a macro running, could someone tell me how to
disallow SAVE AS, this way, I know I will end up with the proper naming
conventions.

Also, could someone read the post above about specifying directories to SAVE
in?

I really appreciate all the help on this site!
Thanks again!

"Marc" wrote:

Well, why don't you just make the file read only? Then the only way to save
is "save as"...





Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
I used "save as" but now can't locate original file Booksmarts Excel Discussion (Misc queries) 1 December 1st 05 09:15 PM
"save changes" prompt missing Dennis Excel Discussion (Misc queries) 0 October 31st 05 05:32 AM


All times are GMT +1. The time now is 09:28 AM.

Powered by vBulletin® Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright 2004-2020 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017