AboutBill Expertise I can provide help with most all EXCEL questions and most all questions about
writing EXCEL macros. I have been developing macros for about 10 years in
EXCEL and have switched to it from Lotus 1-2-3 after about 10 years of writing
macros in it. Typically, I will not write a macro for you unless it is very short because of all the details a macro has to know about to work every time all the time. Please understand that I do not know it all and will be the first to say so.
As politely as possible, I don't write macros for people on this site who need one, want one, seem to imply that they need one, and/or seem to think I am expected to write one UNLESS they are very short, quick, and simple.
99% of all macros are more involved than what you think and rarely am I provided with enough specific and complete details to have the code work the first time and every time. This typically means too many follow-up emails, and subsequent macro changes due to lack of specific details, just to get those details so that the macro would work, all of which is on my own free time.
The voice of experience from responding to many questions from people who ask me to write a macro for them from this site tells me this. I don't mean to come across as unhelpful but macros are usually very specific and without ALL of the specifics the macro I would write will not address all of your needs and the layout, location, formatting, conditions, etc. of your data and any related files the macro would have to work with.
What seems like a simple task to you is almost always more involved than what you think to have the macro ALWAYS work in EVERY situation.
If you have a macro you have already written and have a question about it then perhaps I could help with that. I am sure and hope you can and do understand.
Hi,
Last month, one of you here at AllExperts answered my question about using a macro to time out a file hog, which worked great, but now she has figured out and does almost daily that she can go right back into a second, third, etc., session after timing out of the first one, so essentially, she still has the spreadsheet open exclusively all day long. (Communication doesn't work .. we've tried!) So my next current questions are:
(1) Is there a way to limit the number of daily access session for each user?
(2) Is there a way to modify the original time-out code (or add a new one) that requires all users to "Enable Macro" or otherwise, access is not granted?
Thanks so much in advance!
Robbin
Answer The snapshot of the code was too small to read so I don't know what that person was doing and therefore don't how to put a limit on what the user does. But code can be written to do that sort of thing. I suggest asking the person who answered your question.
This service is not just a big room where a bunch of EXCEL users sit around and play with EXCEL all day. We are all just volunteers offering our time and knowledge and get questions from this site. i don't know what other volunteers do, know the questions they get, or know the answers they provide. The same applies to them about me.
Secondly, the ONLY way for this to work is to use macros and if the user does not enable macros then you are out of luck. However, you can force the idiot to enable macros by playing a lot of "tricks" with the data and the sheets. You can hide all sheets and lock all cells in the wb. The ONLY way to display the sheets and unlock the cells is to enable macros so that macros can then display the sheets and unlock the cells. This can be done on the Open event of the workbook and the locking and hiding can be done on the close event.
You can make sheets be VERY hidden via code only so that a use can not see the sheet names to then unhide them in normal EXCEL use.
Or, upon opening the workbook have code make a copy of the file and then close the original one for this idiot to use and for this idiot work in that file all day. Then you will have to do some kind of data combining, I suspect.
About Excel
This topic answers questions related to Microsoft Excel spreadsheet (or workbook) stand-alone or Mircrosoft Office Excel including Excel 2003, Excel 2007, Office 2000, and Office XP. You can get Excel help on Excel formulas(or functions), Excell macros, charting in Excel, advanced features, and the general use of Excel. This does not provide a general Excel tutorial nor the basics of using a spreadsheet. It provides specific answers to using Microsoft Excel only. If you do not see your Excel question answered in this area then please ask an Excel question here
)