Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Any macro experts out there? | Excel Worksheet Functions | |||
for the experts | Excel Discussion (Misc queries) | |||
again for the experts | Excel Discussion (Misc queries) | |||
Help - Need experts help! | Excel Discussion (Misc queries) | |||
another for the experts | Excel Discussion (Misc queries) |