Dear members,
We have received concerns from few posters that there subject line of their
topic was changed by other members. Please note that this is the violation of
group policy.
I request you to maintain decorum of the group.
Any member found doing this again will be banned permanently from the group.
Hi Mageshwaran,
Please don't do this again in future.
Hi TAIgo,
Our apologies to you. Thanks for keeping us updated about such violation
KEEP POSTING !
Best regards,
Ayush Jain
--- On Sat, 1/8/09, mageshwaran jayaraman <macwa...@yahoo.co.in> wrote:
From: mageshwaran jayaraman <macwa...@yahoo.co.in>
Subject: $$Excel-Macros$$ Using Protection in a Subtotal Sheet
To: excel-macros@googlegroups.com
Date: Saturday, 1 August, 2009, 12:32 PM
Hi Guys,
Need a small favour/suggestion.
I've created an excel fail where I insert datas on daily basis and take a
summary report at the end of the month.
For a daily summary, I've used DATA > SUBTOTAL function, wherein I get the
summary in sheet 2(out of total 3 sheets which is automatically created when
Subtotal function is used) and the daily entry is inserted in sheet 3.
Now my problem is when I am trying to protect the sheet 3 using TOOLS >
PROTECTION > PROTECT SHEET so that no body plays with the numerous formulas
that I have put there, I'm not able to access the other 2 sheets.
Let me know if I'd made myself clear or else I wud attach an sample excel file.
Thanx 'n' rgds,
Mageshwaran J.
Yahoo! recommends that you upgrade to the new and safer Internet
Explorer 8.
See the Web's breaking stories, chosen by people like you. Check out
Yahoo! Buzz. http://in.buzz.yahoo.com/
--~--~---------~--~----~------------~-------~--~----~
----------------------------------------------------------------------------------
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at
http://www.excelitems.com
2. Excel tutorials at http://www.excel-macros.blogspot.com
3. Learn VBA Macros at http://www.vbamacros.blogspot.com
4. Excel Tips and Tricks at http://exceldailytip.blogspot.com
To post to this group, send email to excel-macros@googlegroups.com
If you find any spam message in the group, please send an email to:
Ayush Jain @ jainayus...@gmail.com or
Ashish Jain @ 26may.1...@gmail.com
<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!
We reach over 5,200 subscribers worldwide and receive many nice notes about the
learning and support from the group. Our goal is to have 10,000 subscribers by
the end of 2009. Let friends and co-workers know they can subscribe to group at
http://groups.google.com/group/excel-macros/subscribe
-~----------~----~----~----~------~----~------~--~---
