I am a regular visitor of this site and am also very much thankful to all
those experts who are spending so much of their precious time at this site
for giving replies / solving problems of others. I had also posted some
questions herebefore and have received nice answers to the same.

SOMEHOW I HV NOT RECD REPLY/IES TO MY FOLLOWING EARLIER POSTS :

1. We are working on a project and since now hard disk drives are available
in
huge capacity, it's just becoming impossible for us to restrict "copy"ing or
"save as" functions.
what we are trying to do is create some sort of support file/s and keep them
in some other locations on the computer and ask thru VBA if those specified
files are there, then only open the file. Now we have came across a bug in
this.

under tools-macro-security option, if the security level is set to LOW, the
VBA code is set aside and the file opens. How to avoid this and is there any
other full proof system in excel which can prevent user from surpassing the
restrictions imposed thru VBA code and also copy and/or save as function ??


2. i m using office 2000. i wonder when i put manual page break in excel,
fill
in data in it and if i try to insert a row on the row immediately after the
page break, it goes in the upper page. however if i insert row on the second
row, it adds a row at no. 2 on the page. is there any way to add row on the
first position after page break ???

I would like to know whether this is not possible or there is a bug in the
software installation at my pc ??

If it is possible, then a way to do it .........

tks in advance

and also to this post :
in excel 2000, i have a column formatted as general. if i edit the same, do
or does not chage the value of the cell, and press enter it automatically get
changed to "MM/DD/YYYY" format . what could be the reason and remedy for
the same.

#1. Excel's macro security setting is made to protect the user--not the
developer. You can't force the users to open your files with macros enabled.
(When macro security is set to Low, your macros should run--probably a typo in
your post, right???)

Maybe you can break your workbook if macros are disabled.

Harlan Grove recommended that you add a UDF (user defined function) that is
essentially a do nothing function. But if macros are disabled, then the UDF
will fail.

Then you include this function in very important formulas.

Option Explicit
Function iFunc() As Long
iFunc = 1
End Function


Then in an important/complex formula that returns a number:

=if(...)*someotherformula*ifunc()

If macros are disabled (and depending on the version of excel that the user is
using -- and the user hasn't changed any register settings!), then when the file
is opened with macros disabled, the function will return a #NAME? error.

If you do it in enough spots (and all that other stuff is still true), then you
may stop the user from being able to do anything with your workbook.

#2. That's the way xl2003 works, too. I'd bet it was a design choice and not a
bug.

YESHWANT wrote:

I am a regular visitor of this site and am also very much thankful to all
those experts who are spending so much of their precious time at this site
for giving replies / solving problems of others. I had also posted some
questions herebefore and have received nice answers to the same.

SOMEHOW I HV NOT RECD REPLY/IES TO MY FOLLOWING EARLIER POSTS :

1. We are working on a project and since now hard disk drives are available
in
huge capacity, it's just becoming impossible for us to restrict "copy"ing or
"save as" functions.
what we are trying to do is create some sort of support file/s and keep them
in some other locations on the computer and ask thru VBA if those specified
files are there, then only open the file. Now we have came across a bug in
this.

under tools-macro-security option, if the security level is set to LOW, the
VBA code is set aside and the file opens. How to avoid this and is there any
other full proof system in excel which can prevent user from surpassing the
restrictions imposed thru VBA code and also copy and/or save as function ??

2. i m using office 2000. i wonder when i put manual page break in excel,
fill
in data in it and if i try to insert a row on the row immediately after the
page break, it goes in the upper page. however if i insert row on the second
row, it adds a row at no. 2 on the page. is there any way to add row on the
first position after page break ???

I would like to know whether this is not possible or there is a bug in the
software installation at my pc ??

If it is possible, then a way to do it .........

tks in advance

--

Dave Peterson

We're here ... but sometimes the system gives us headaches. It's been that
way for me for a couple of days now when using the HTML interface - I've not
been able to reply to anyone about anything for at least the last 36 hours
due to server error.

Then again, sometimes the people reading a plea for help simply don't have
an answer and rather than posting something like "sorry, I can't help but I
hope someone who can comes along soon", we just pass on by. Not to try to
sound too infatuated with my status (one of the MVP group), but I also fear
that if someone sees MVP next to a name in a reply that they may assume I
actually provided some kind of useful assistance, so again I keep my fingers
off of the keyboard unless I actually have some little bit of help to offer.
I know when I see someone's name as a reply poster and I know them to be an
MVP or otherwise really sharp Excel person, I figure things are in good hands.

"YESHWANT" wrote:

I am a regular visitor of this site and am also very much thankful to all
those experts who are spending so much of their precious time at this site
for giving replies / solving problems of others. I had also posted some
questions herebefore and have received nice answers to the same.

SOMEHOW I HV NOT RECD REPLY/IES TO MY FOLLOWING EARLIER POSTS :

1. We are working on a project and since now hard disk drives are available
in
huge capacity, it's just becoming impossible for us to restrict "copy"ing or
"save as" functions.
what we are trying to do is create some sort of support file/s and keep them
in some other locations on the computer and ask thru VBA if those specified
files are there, then only open the file. Now we have came across a bug in
this.

under tools-macro-security option, if the security level is set to LOW, the
VBA code is set aside and the file opens. How to avoid this and is there any
other full proof system in excel which can prevent user from surpassing the
restrictions imposed thru VBA code and also copy and/or save as function ??


2. i m using office 2000. i wonder when i put manual page break in excel,
fill
in data in it and if i try to insert a row on the row immediately after the
page break, it goes in the upper page. however if i insert row on the second
row, it adds a row at no. 2 on the page. is there any way to add row on the
first position after page break ???

I would like to know whether this is not possible or there is a bug in the
software installation at my pc ??

If it is possible, then a way to do it .........

tks in advance

Hi Dave Peterson,

Thanks for your response so early.

for no. 1 of your reply, will it be possible for you to give me detailed
procedure and complete code since I can work good (to some extent, not master
as you) but not really using VB unelss it is done by my fellow members.

for no. 2 - what is the solution then if I want to add row at the top of the
page (except removing and/or reinstating the page break)

"Dave Peterson" wrote:

#1. Excel's macro security setting is made to protect the user--not the
developer. You can't force the users to open your files with macros enabled.
(When macro security is set to Low, your macros should run--probably a typo in
your post, right???)

Maybe you can break your workbook if macros are disabled.

Harlan Grove recommended that you add a UDF (user defined function) that is
essentially a do nothing function. But if macros are disabled, then the UDF
will fail.

Then you include this function in very important formulas.

Option Explicit
Function iFunc() As Long
iFunc = 1
End Function


Then in an important/complex formula that returns a number:

=if(...)*someotherformula*ifunc()

If macros are disabled (and depending on the version of excel that the user is
using -- and the user hasn't changed any register settings!), then when the file
is opened with macros disabled, the function will return a #NAME? error.

If you do it in enough spots (and all that other stuff is still true), then you
may stop the user from being able to do anything with your workbook.

#2. That's the way xl2003 works, too. I'd bet it was a design choice and not a
bug.

YESHWANT wrote:

I am a regular visitor of this site and am also very much thankful to all
those experts who are spending so much of their precious time at this site
for giving replies / solving problems of others. I had also posted some
questions herebefore and have received nice answers to the same.

SOMEHOW I HV NOT RECD REPLY/IES TO MY FOLLOWING EARLIER POSTS :

1. We are working on a project and since now hard disk drives are available
in
huge capacity, it's just becoming impossible for us to restrict "copy"ing or
"save as" functions.
what we are trying to do is create some sort of support file/s and keep them
in some other locations on the computer and ask thru VBA if those specified
files are there, then only open the file. Now we have came across a bug in
this.

under tools-macro-security option, if the security level is set to LOW, the
VBA code is set aside and the file opens. How to avoid this and is there any
other full proof system in excel which can prevent user from surpassing the
restrictions imposed thru VBA code and also copy and/or save as function ??

2. i m using office 2000. i wonder when i put manual page break in excel,
fill
in data in it and if i try to insert a row on the row immediately after the
page break, it goes in the upper page. however if i insert row on the second
row, it adds a row at no. 2 on the page. is there any way to add row on the
first position after page break ???

I would like to know whether this is not possible or there is a bug in the
software installation at my pc ??

If it is possible, then a way to do it .........

tks in advance

--

Dave Peterson

#1. I included code that would do it. And I tried to show how you'd change an
existing formula.

If you're new to macros:

Debra Dalgleish has some notes how to implement macros he
http://www.contextures.com/xlvba01.html

David McRitchie has an intro to macros:
http://www.mvps.org/dmcritchie/excel/getstarted.htm

Ron de Bruin's intro to macros:
http://www.rondebruin.nl/code.htm

(General, Regular and Standard modules all describe the same thing.)


#2. That is the solution.

YESHWANT wrote:

Hi Dave Peterson,

Thanks for your response so early.

for no. 1 of your reply, will it be possible for you to give me detailed
procedure and complete code since I can work good (to some extent, not master
as you) but not really using VB unelss it is done by my fellow members.

for no. 2 - what is the solution then if I want to add row at the top of the
page (except removing and/or reinstating the page break)

"Dave Peterson" wrote:

#1. Excel's macro security setting is made to protect the user--not the
developer. You can't force the users to open your files with macros enabled.
(When macro security is set to Low, your macros should run--probably a typo in
your post, right???)

Maybe you can break your workbook if macros are disabled.

Harlan Grove recommended that you add a UDF (user defined function) that is
essentially a do nothing function. But if macros are disabled, then the UDF
will fail.

Then you include this function in very important formulas.

Option Explicit
Function iFunc() As Long
iFunc = 1
End Function


Then in an important/complex formula that returns a number:

=if(...)*someotherformula*ifunc()

If macros are disabled (and depending on the version of excel that the user is
using -- and the user hasn't changed any register settings!), then when the file
is opened with macros disabled, the function will return a #NAME? error.

If you do it in enough spots (and all that other stuff is still true), then you
may stop the user from being able to do anything with your workbook.

#2. That's the way xl2003 works, too. I'd bet it was a design choice and not a
bug.

YESHWANT wrote:

I am a regular visitor of this site and am also very much thankful to all
those experts who are spending so much of their precious time at this site
for giving replies / solving problems of others. I had also posted some
questions herebefore and have received nice answers to the same.

SOMEHOW I HV NOT RECD REPLY/IES TO MY FOLLOWING EARLIER POSTS :

1. We are working on a project and since now hard disk drives are available
in
huge capacity, it's just becoming impossible for us to restrict "copy"ing or
"save as" functions.
what we are trying to do is create some sort of support file/s and keep them
in some other locations on the computer and ask thru VBA if those specified
files are there, then only open the file. Now we have came across a bug in
this.

under tools-macro-security option, if the security level is set to LOW, the
VBA code is set aside and the file opens. How to avoid this and is there any
other full proof system in excel which can prevent user from surpassing the
restrictions imposed thru VBA code and also copy and/or save as function ??

2. i m using office 2000. i wonder when i put manual page break in excel,
fill
in data in it and if i try to insert a row on the row immediately after the
page break, it goes in the upper page. however if i insert row on the second
row, it adds a row at no. 2 on the page. is there any way to add row on the
first position after page break ???

I would like to know whether this is not possible or there is a bug in the
software installation at my pc ??

If it is possible, then a way to do it .........

tks in advance

--

Dave Peterson


--

Dave Peterson