Dan Said:

Microsoft Excel VBA Calculating and Message Boxes?

We Answered:

Hi James...

Here are a couple of possible ideas. The first is to use the 'DoEvents' function. Here is a link to an example of what it is and how it works.

http://en.allexperts.com/q/Visual-Basic-…

The second would be, not so elegantly, to move the 'msgbox' portion of the macro to a second macro, and then call that macro from the point in your first one that it would have fired. Sometimes this 'workaround' works....

Good luck!

Eileen Said:

How do I make a calculation template in Excel ?

We Answered:

You need to protect the cells with the calculations. It's counterintuitive, but you need to unlock all the cells where people need to enter data in order to do this. That's because all cells are "locked" by default. The lock doesn't actually take effect until you protect the worksheet though. Think of it as a deadbolt on a door. Having the cell formatted as "locked" is like having a deadbolt. The deadbolt doesn't do anything unless you actually turn the handle though; that's what protecting does.

First, select the cells which users need to be able to change. If you are only worried about protecting formulas and are OK if the users change any straight data, the quickest way to do this is Edit > Go To. Click Special, select Constants, and click OK. If everything users need to change is in one contiguous range, you can just highlight it.

Second, you have to unlock the cells which users need to change. Select Format > Cells. Go to the Protection tab. Uncheck the box for Locked and click OK.

Third, you need to protect the worksheet. Select Tools > Protection > Protect Sheet. If you want to add a password, you can do so here. However, if you forget the password, you can't get it back; this isn't something your system administrator can reset like your Windows password. Then choose the options for what your users should be allowed to do. If you don't want them to even be able to click on the formulas, uncheck the box for Select locked cells. If they need to be able to format cells or add rows or columns, check those options. Once you have everything set the way you want, click OK.

This should make the spreadsheet work even just saved as a regular workbook and not a template. You can save it as a template, but I'm not sure if that would make it more complicated for your customers. To save as a template, select File > Save As and change the file type to an Excel Template (.xlt). If you're sending the workbook out to your customers each month though, I think you may be able to skip that step.

There is an option in Excel 2002 and 2003 called Allow Users to Edit Ranges. I didn't explain that option because it requires either a password or to set up permissions. I'm guessing your customers aren't on the same network as you, which makes permissions pretty much impossible. I also didn't want to make your customers enter a password; it seems like extra hassle for them that you can avoid by keeping a password just for yourself. However, if my assumptions are wrong, that is an option for you to explore besides what I explained here.

Steven Said:

Please I need help with these few questions. And yes I know its my homework but I need help with it. Thanks’?

We Answered:

Number 7 is A.
Sorry I haven't read the others.. better than nothing though.
have fun

Catherine Said:

Are there any templates for daily activity reports for preschool?

We Answered:

If you send a note home for every child every day you're setting yourself up for a LOT of work, especially if you're only there half a day. Do you mean just how their mood was, toileting, snack, that sort of thing? I've included some links to what I think you're looking for.


If I were you, I would make my own. I didn't do a daily one for preschoolers, but when I taught toddlers, we sent home a note something along the lines of "Today Mary was really busy in the block area. She and Johnny built an airplane. I really loved watching them share the blocks and engage in this play together." Things like that. Just a few sentences. We didn't send every child a note every day, but we wrote about 3-5 notes each day and kept track of who had one and who didn't. If the child did something spectacularly interesting or something, we might send an extra note.

Another option is to have communication notebooks. They keep them in their backpacks. Give them to you each day. You check to see if parents wrote anything to you. Answer if needed. Write a note in some of the notebooks every day, or as many as you have time for. Then the notebook goes back in the backpack and goes home each day.

Another idea for saving paper and time: If you want parents to know what was going on at school each day, how about getting a big dry erase board. Make permanent sections for each area like "Music, Art, Blocks, Dramatic Play": whatever is most important to you. Then each day you can write in "We sang X" or "We did marble painting." Even have a circle time just before going home and ask the kids to tell you what to put. Post the dry erase board where parents can see it.

Julio Said:

Need to design a tracking form to keep track of printing in the office - any ideas?

We Answered:

Try this freeware papercut print logger which can be download at
http://www.papercut.com/products/free_so…
Install at least on the pc that attached to the printer on peer-to-peer network(normal small office/home office configuration).
After installation, it will provide instant daily and monthly report of print status in html or csv(excel) format
The info of the report include Time, User, Pages, Copies, Printer, Document Name, Client(pc name in network), Paper Size, Language(printer mode actually), Size(of print job in kb) etc.
The only thing after installation is to keep the log file from tampering, may be take down the location of the log, then delete the folder "Papercut Print logger" in start, all programs list.
Hope this help.