Access Rights & Reports

**John F.M.** · 05-31-2005, 04:00 PM

Is there a way to create access rights for certain people for certain cells of certain worksheets?

Also, is there a way to query a worksheet to produce a report? For example, if I produced a sheet that documented whether something was approved or not, could I query the sheet and produce a report that says what is approved?

CLR · 05-31-2005, 05:05 PM

Hi John............
To answer your first question, Yes, virtually anything can be done with VBA
code. Although, be warned, the security of Excel is meant to keep only the
honest people out.........Pros can still get in if they want to.

For your second question, again, yes, many nifty things can be done with
VBA, however in this case, the AutoFilter function might be a quick way to
see only what you want to............

Post back with more specifics if you need more details..........

Vaya con Dios,
Chuck, CABGx3

"John F.M." <John.F.M..1pwwul_1117569923.0638@excelforum-nospam.com> wrote
in message news:John.F.M..1pwwul_1117569923.0638@excelforum-nospam.com...
>
> Is there a way to create access rights for certain people for certain
> cells of certain worksheets?
>
> Also, is there a way to query a worksheet to produce a report? For
> example, if I produced a sheet that documented whether something was
> approved or not, could I query the sheet and produce a report that says
> what is approved?
>
>
> --
> John F.M.
> ------------------------------------------------------------------------
> John F.M.'s Profile:
http://www.excelforum.com/member.php...o&userid=23782
> View this thread: http://www.excelforum.com/showthread...hreadid=375317
>

CLR · 09-05-2005, 10:05 PM

Hi John............
To answer your first question, Yes, virtually anything can be done with VBA
code. Although, be warned, the security of Excel is meant to keep only the
honest people out.........Pros can still get in if they want to.

For your second question, again, yes, many nifty things can be done with
VBA, however in this case, the AutoFilter function might be a quick way to
see only what you want to............

Post back with more specifics if you need more details..........

Vaya con Dios,
Chuck, CABGx3

"John F.M." <John.F.M..1pwwul_1117569923.0638@excelforum-nospam.com> wrote
in message news:John.F.M..1pwwul_1117569923.0638@excelforum-nospam.com...
>
> Is there a way to create access rights for certain people for certain
> cells of certain worksheets?
>
> Also, is there a way to query a worksheet to produce a report? For
> example, if I produced a sheet that documented whether something was
> approved or not, could I query the sheet and produce a report that says
> what is approved?
>
>
> --
> John F.M.
> ------------------------------------------------------------------------
> John F.M.'s Profile:
http://www.excelforum.com/member.php...o&userid=23782
> View this thread: http://www.excelforum.com/showthread...hreadid=375317
>

CLR · 09-05-2005, 11:05 PM

Hi John............
To answer your first question, Yes, virtually anything can be done with VBA
code. Although, be warned, the security of Excel is meant to keep only the
honest people out.........Pros can still get in if they want to.

For your second question, again, yes, many nifty things can be done with
VBA, however in this case, the AutoFilter function might be a quick way to
see only what you want to............

Post back with more specifics if you need more details..........

Vaya con Dios,
Chuck, CABGx3

"John F.M." <John.F.M..1pwwul_1117569923.0638@excelforum-nospam.com> wrote
in message news:John.F.M..1pwwul_1117569923.0638@excelforum-nospam.com...
>
> Is there a way to create access rights for certain people for certain
> cells of certain worksheets?
>
> Also, is there a way to query a worksheet to produce a report? For
> example, if I produced a sheet that documented whether something was
> approved or not, could I query the sheet and produce a report that says
> what is approved?
>
>
> --
> John F.M.
> ------------------------------------------------------------------------
> John F.M.'s Profile:
http://www.excelforum.com/member.php...o&userid=23782
> View this thread: http://www.excelforum.com/showthread...hreadid=375317
>

CLR · 09-06-2005, 12:05 AM

Hi John............
To answer your first question, Yes, virtually anything can be done with VBA
code. Although, be warned, the security of Excel is meant to keep only the
honest people out.........Pros can still get in if they want to.

For your second question, again, yes, many nifty things can be done with
VBA, however in this case, the AutoFilter function might be a quick way to
see only what you want to............

Post back with more specifics if you need more details..........

Vaya con Dios,
Chuck, CABGx3

"John F.M." <John.F.M..1pwwul_1117569923.0638@excelforum-nospam.com> wrote
in message news:John.F.M..1pwwul_1117569923.0638@excelforum-nospam.com...
>
> Is there a way to create access rights for certain people for certain
> cells of certain worksheets?
>
> Also, is there a way to query a worksheet to produce a report? For
> example, if I produced a sheet that documented whether something was
> approved or not, could I query the sheet and produce a report that says
> what is approved?
>
>
> --
> John F.M.
> ------------------------------------------------------------------------
> John F.M.'s Profile:
http://www.excelforum.com/member.php...o&userid=23782
> View this thread: http://www.excelforum.com/showthread...hreadid=375317
>

CLR · 09-06-2005, 01:05 AM

Hi John............
To answer your first question, Yes, virtually anything can be done with VBA
code. Although, be warned, the security of Excel is meant to keep only the
honest people out.........Pros can still get in if they want to.

For your second question, again, yes, many nifty things can be done with
VBA, however in this case, the AutoFilter function might be a quick way to
see only what you want to............

Post back with more specifics if you need more details..........

Vaya con Dios,
Chuck, CABGx3

"John F.M." <John.F.M..1pwwul_1117569923.0638@excelforum-nospam.com> wrote
in message news:John.F.M..1pwwul_1117569923.0638@excelforum-nospam.com...
>
> Is there a way to create access rights for certain people for certain
> cells of certain worksheets?
>
> Also, is there a way to query a worksheet to produce a report? For
> example, if I produced a sheet that documented whether something was
> approved or not, could I query the sheet and produce a report that says
> what is approved?
>
>
> --
> John F.M.
> ------------------------------------------------------------------------
> John F.M.'s Profile:
http://www.excelforum.com/member.php...o&userid=23782
> View this thread: http://www.excelforum.com/showthread...hreadid=375317
>

CLR · 09-06-2005, 02:05 AM

Hi John............
To answer your first question, Yes, virtually anything can be done with VBA
code. Although, be warned, the security of Excel is meant to keep only the
honest people out.........Pros can still get in if they want to.

For your second question, again, yes, many nifty things can be done with
VBA, however in this case, the AutoFilter function might be a quick way to
see only what you want to............

Post back with more specifics if you need more details..........

Vaya con Dios,
Chuck, CABGx3

"John F.M." <John.F.M..1pwwul_1117569923.0638@excelforum-nospam.com> wrote
in message news:John.F.M..1pwwul_1117569923.0638@excelforum-nospam.com...
>
> Is there a way to create access rights for certain people for certain
> cells of certain worksheets?
>
> Also, is there a way to query a worksheet to produce a report? For
> example, if I produced a sheet that documented whether something was
> approved or not, could I query the sheet and produce a report that says
> what is approved?
>
>
> --
> John F.M.
> ------------------------------------------------------------------------
> John F.M.'s Profile:
http://www.excelforum.com/member.php...o&userid=23782
> View this thread: http://www.excelforum.com/showthread...hreadid=375317
>

CLR · 09-06-2005, 03:05 AM

Hi John............
To answer your first question, Yes, virtually anything can be done with VBA
code. Although, be warned, the security of Excel is meant to keep only the
honest people out.........Pros can still get in if they want to.

For your second question, again, yes, many nifty things can be done with
VBA, however in this case, the AutoFilter function might be a quick way to
see only what you want to............

Post back with more specifics if you need more details..........

Vaya con Dios,
Chuck, CABGx3

"John F.M." <John.F.M..1pwwul_1117569923.0638@excelforum-nospam.com> wrote
in message news:John.F.M..1pwwul_1117569923.0638@excelforum-nospam.com...
>
> Is there a way to create access rights for certain people for certain
> cells of certain worksheets?
>
> Also, is there a way to query a worksheet to produce a report? For
> example, if I produced a sheet that documented whether something was
> approved or not, could I query the sheet and produce a report that says
> what is approved?
>
>
> --
> John F.M.
> ------------------------------------------------------------------------
> John F.M.'s Profile:
http://www.excelforum.com/member.php...o&userid=23782
> View this thread: http://www.excelforum.com/showthread...hreadid=375317
>