Prev: Answer Message Box - Other than Y/N?
Next: Using Color as Criteria in Countif Function
From: Jim Berglund on 24 May 2010 12:03
I just built an applet and want others to be able to use it. Essentially,
when you press the RUN button, it automatically opens 3 files located on
the users' desktop, based upon the answers he provides in two input boxes,
reformats, manipulates the data, eliminates unwanted data and then presents
the data to the user in a form he can use.

I only want the user to be able to input the two data elements, and use the
RUN button - nothing else. I don't even want the applet to be re-saved with
the new data shown - although I'd like him to be able to copy the processed
data into another file.

Is this possible? How can I do this?

Jim Berglund

From: AB on 24 May 2010 17:17
Not sure if i got your question right but how about
tools>protection>protect workbook?
Doesn't it do what you want?

On May 24, 5:03 pm, "Jim Berglund" <jazz...(a)shaw.ca> wrote:
> I just built an applet and want others to be able to use it. Essentially,
> when you press the RUN button,  it automatically opens 3 files located on
> the users' desktop, based upon the answers he provides in two input boxes,
> reformats,  manipulates the data, eliminates unwanted data and then presents
> the data to the user in a form he can use.
>
> I only want the user to be able to input the two data elements, and use the
> RUN button - nothing else. I don't even want the applet to be re-saved with
> the new data shown - although I'd like him to be able to copy the processed
> data into another file.
>
> Is this possible? How can I do this?
>
> Jim Berglund

From: Jim Berglund on 24 May 2010 18:16
I wish it was that easy... I tried that but get an error code when I press
the RUN button. Is there a way to allow the procedure to run (and change the
contents of cells) without allowing the user to mess with the data - or
anything else?

Jim

"AB" <austris.bahanovskis(a)gmail.com> wrote in message
news:e64a8384-d213-442c-af6e-4b41b77b30b5(a)s41g2000vba.googlegroups.com...
> Not sure if i got your question right but how about
> tools>protection>protect workbook?
> Doesn't it do what you want?
>
> On May 24, 5:03 pm, "Jim Berglund" <jazz...(a)shaw.ca> wrote:
>> I just built an applet and want others to be able to use it. Essentially,
>> when you press the RUN button, it automatically opens 3 files located on
>> the users' desktop, based upon the answers he provides in two input
>> boxes,
>> reformats, manipulates the data, eliminates unwanted data and then
>> presents
>> the data to the user in a form he can use.
>>
>> I only want the user to be able to input the two data elements, and use
>> the
>> RUN button - nothing else. I don't even want the applet to be re-saved
>> with
>> the new data shown - although I'd like him to be able to copy the
>> processed
>> data into another file.
>>
>> Is this possible? How can I do this?
>>
>> Jim Berglund
>
From: Project Mangler on 25 May 2010 03:04
Have you tried something like

Worksheets("Sheet1").Protect Password:="abc", UserInterfaceOnly:=True


"Jim Berglund" <jazzzbo(a)shaw.ca> wrote in message
news:%23GKrS74%23KHA.3880(a)TK2MSFTNGP04.phx.gbl...
> I wish it was that easy... I tried that but get an error code when I press
> the RUN button. Is there a way to allow the procedure to run (and change
the
> contents of cells) without allowing the user to mess with the data - or
> anything else?
>
> Jim
>
> "AB" <austris.bahanovskis(a)gmail.com> wrote in message
> news:e64a8384-d213-442c-af6e-4b41b77b30b5(a)s41g2000vba.googlegroups.com...
> > Not sure if i got your question right but how about
> > tools>protection>protect workbook?
> > Doesn't it do what you want?
> >
> > On May 24, 5:03 pm, "Jim Berglund" <jazz...(a)shaw.ca> wrote:
> >> I just built an applet and want others to be able to use it.
Essentially,
> >> when you press the RUN button, it automatically opens 3 files located
on
> >> the users' desktop, based upon the answers he provides in two input
> >> boxes,
> >> reformats, manipulates the data, eliminates unwanted data and then
> >> presents
> >> the data to the user in a form he can use.
> >>
> >> I only want the user to be able to input the two data elements, and use
> >> the
> >> RUN button - nothing else. I don't even want the applet to be re-saved
> >> with
> >> the new data shown - although I'd like him to be able to copy the
> >> processed
> >> data into another file.
> >>
> >> Is this possible? How can I do this?
> >>
> >> Jim Berglund
> >


From: AB on 25 May 2010 03:58
You could:
1. protect (as per earlier post by Prject Mangler) your wb or ws
(depending on what you want)
2. write your 'Run' code so that it:
2.1. unprotects the wb/ws
2.2. does the thing you want
2.3. re-protects teh wb/ws again.
Additional (not fool-proof) feature you can implement is you can
change your fileaccess to read-only on the fly, if you want to.

This way your file would be 'open' for user to mess about only during
the macro run time (during which they can't mess around with it) or
when it's read-only (and then you almost don't care).
 |  Next  |  Last
Pages: 1 2
Prev: Answer Message Box - Other than Y/N?
Next: Using Color as Criteria in Countif Function