#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