Hi Dave,
Comment "hidden" is used in the vba code and here is the explanation for this.
Sheet1.Visible = xlSheetVeryHidden
or
Sheets("Dilip").Visible = xlSheetVeryHidden
Using above code, you can hide the sheets and then the user can not
unhide the respective sheet by menu command Sheet-> Unhide.
Now, you can not see it using Format->Sheet-> unhide
To get it back, use following code
Sheet1.Visible = True
Or
Sheets("Sheet1").visible = True
Sheets("Dilip").visible = true
I hope this helps.
Best Regards,
DILIPandey
On 3/24/11, Pehrson, Dave <dpehr...@walbro.com> wrote:
> Thanks, Just a question, I had thought of that, but could not find one
> attached to the your spreadsheet. What was I missing. I noticed a
> comment about "hidden" but don't know how that works. Can you provide
> any insight?
>
> Thanks Again
> Dave
>
> -----Original Message-----
> From: Dilip Pandey [mailto:dilipan...@gmail.com]
> Sent: Tuesday, March 22, 2011 1:29 AM
> To: Pehrson, Dave
> Cc: excel-macros@googlegroups.com
> Subject: Re: $$Excel-Macros$$ Macro to Average a series of numbers in
> excel
>
> Oopss...!!
> Quick Solution:- Create a sheet by the name of "backup" in your workbook
> and that's all. All functionality should work fine.
>
> Best Regards,
> DILIPandey
>
> On 3/22/11, Pehrson, Dave <dpehr...@walbro.com> wrote:
>> Dilip, need a little more help, I took your latest update program
>> logic and pasted into an updated spreadsheet, and got an error message
>
>> the "scripts out of range" and drives to the hidden backup file. I'm
>
>> attaching the spread sheet causing the problem, if you get a moment,
>> could you please take a look at it and see if it's an easy fix.
>>
>> Thanks again for all you help
>>
>> Dave
>>
>> -----Original Message-----
>> From: Dilip Pandey [mailto:dilipan...@gmail.com]
>> Sent: Tuesday, March 15, 2011 10:27 PM
>> To: Pehrson, Dave
>> Cc: excel-macros@googlegroups.com
>> Subject: Re: $$Excel-Macros$$ Macro to Average a series of numbers in
>> excel
>>
>> Hi Dave,
>>
>> Sorry for the delay. I was busy with some project deliveries.
>> Please find the attached automation with remove/ reverse/ undo
> facility.
>>
>> Feel free to get back in case of any queries.
>>
>> Thanks,
>> DILIPandey
>>
>> On 3/8/11, Pehrson, Dave <dpehr...@walbro.com> wrote:
>>> Dilip,
>>> As I work with this process, I have found a need to sometimes reverse
>
>>> the process, what would the routine look like to remove / reverse
>>> the
>>
>>> process within the same ranges defined.
>>>
>>> Thanks again for your support
>>> Dave
>>>
>>> -----Original Message-----
>>> From: Dilip Pandey [mailto:dilipan...@gmail.com]
>>> Sent: Wednesday, March 02, 2011 10:17 PM
>>> To: excel-macros@googlegroups.com
>>> Cc: Pehrson, Dave
>>> Subject: Re: $$Excel-Macros$$ Macro to Average a series of numbers in
>
>>> excel
>>>
>>> Hi Dave,
>>>
>>> This is a kind of realistic problem which many user faces on daily
>>> basis. I have designed the solution for you which you can further
>>> customize as per your changing requirements. See the attached file
>>> and feel free to get back in case of any help required. :)
>>>
>>> Thanks & Best Regards,
>>> DILIPandey
>>>
>>> On 3/1/11, Pehrson, Dave <dpehr...@walbro.com> wrote:
>>>> Thanks for your interest in this problem,
>>>>
>>>> My intent in this process, as you can see in the attached example,
>>>> is
>>
>>>> to help automate the process of leveling monthly quantities into
>>>> weekly quantities. There are too many variables to develop an
>>>> algorithm to determine which cells to level, and which cells not to
>>>> level, so I want the production planner to make the decision and
>>>> perform the function of calculating the average over the
>>>> predetermined
>>> period.
>>>>
>>>> In the example in Yellow, the planner would place the curser in cell
>>>> J22 and press the macro button 5 weeks. The macro I started
>>>> highlights the
>>>> 5 week period, what I want to do is extend the logic to add the
>>>> contents of the range selected, divide the sum by 5 (roundedup,0)
>>>> and
>>
>>>> place the results in each of the cells in the selected area
>>>>
>>>> In the example in Blue, the planner would place the curser in cell
>>>> O22
>>>
>>>> and press the macro button 4 weeks. The macro I started highlights
>>>> the
>>>> 4 week period, what I want to do is extend the logic to add the
>>>> contents of the range selected, divide the sum by 5 (roundedup,0)
>>>> and
>>
>>>> place the results in each of the cells in the selected area
>>>>
>>>> Row 23 contains the numbers that I would like to see in row 22.
>>>> (this
>>>
>>>> row is only to show the example)
>>>>
>>>> Thanks for any help you can offer. I'm not a programmer, and often
>>>> don't develop the most effective solutions, so in you see a better
>>>> approach I would love your input.
>>>>
>>>> Dave
>>>>
>>>> -----Original Message-----
>>>> From: excel-macros@googlegroups.com
>>>> [mailto:excel-macros@googlegroups.com] On Behalf Of Dilip Pandey
>>>> Sent: Sunday, February 27, 2011 10:46 AM
>>>> To: excel-macros@googlegroups.com
>>>> Subject: Re: $$Excel-Macros$$ Macro to Average a series of numbers
>>>> in
>>
>>>> excel
>>>>
>>>> Hi Dave,
>>>>
>>>> Please attach a sample file while replying to this email.
>>>>
>>>> Thanks,
>>>> DILIPandey
>>>>
>>>> On 2/25/11, Diamond Dave <dpehr...@walbro.com> wrote:
>>>>> Expert Team,
>>>>> I'm struck. What I'm trying to do is create a macro that will
>>>>> average
>>>>
>>>>> a series of numbers and replace the numbers in the predefined
>>>>> series
>>
>>>>> with that average number. Currently I'm assuming two variables.
>>>>> One
>>>
>>>>> macro for a set of 4 numbers, and one set for a series of 5
> numbers.
>>>>> The following is an example of a series of 4. I you can help with
>>>>> this, I can use the example to create the process for a series of 5
>>>>> 1. I will identify a range of numbers
>>>>> X a b c d e f g
>>>>> 1 1000 0 0 1000 B to E is the range
>>>> selected to average
>>>>> 500 500
>>>>> 500 500 the numbers ro replace above numbers
>>>>>
>>>>> Any support will be appreciated.
>>>>>
>>>>> --
>>>>> -------------------------------------------------------------------
>>>>> -
>>>>> -
>>>>> -
>>>>> ------------
>>>>> Some important links for excel users:
>>>>> 1. Follow us on TWITTER for tips tricks and links :
>>>>> http://twitter.com/exceldailytip
>>>>> 2. Join our LinkedIN group @
>>>>> http://www.linkedin.com/groups?gid=1871310
>>>>> 3. Excel tutorials at http://www.excel-macros.blogspot.com
>>>>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel
>>>>> Tips
>>>
>>>>> and Tricks at http://exceldailytip.blogspot.com
>>>>>
>>>>> To post to this group, send email to excel-macros@googlegroups.com
>>>>>
>>>>> <><><><><><><><><><><><><><><><><><><><><><>
>>>>> Like our page on facebook , Just follow below link
>>>>> http://www.facebook.com/discussexcel
>>>>>
>>>>
>>>>
>>>> --
>>>> Thanks & Regards,
>>>>
>>>> DILIP KUMAR PANDEY, mvp
>>>> MBA,B.Com(Hons),BCA
>>>> Mobile: +91 9810929744
>>>> dilipan...@gmail.com
>>>> dilipan...@yahoo.com
>>>> New Delhi - 62, India
>>>>
>>>> --
>>>> --------------------------------------------------------------------
>>>> -
>>>> -
>>>> --
>>>> ----------
>>>> Some important links for excel users:
>>>> 1. Follow us on TWITTER for tips tricks and links :
>>>> http://twitter.com/exceldailytip 2. Join our LinkedIN group @
>>>> http://www.linkedin.com/groups?gid=1871310
>>>> 3. Excel tutorials at http://www.excel-macros.blogspot.com
>>>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel
>>>> Tips
>>
>>>> and Tricks at http://exceldailytip.blogspot.com
>>>>
>>>> To post to this group, send email to excel-macros@googlegroups.com
>>>>
>>>> <><><><><><><><><><><><><><><><><><><><><><>
>>>> Like our page on facebook , Just follow below link
>>>> http://www.facebook.com/discussexcel
>>>>
>>>> --
>>>> --------------------------------------------------------------------
>>>> -
>>>> -
>>>> ------------
>>>> Some important links for excel users:
>>>> 1. Follow us on TWITTER for tips tricks and links :
>>>> http://twitter.com/exceldailytip
>>>> 2. Join our LinkedIN group @
>>>> http://www.linkedin.com/groups?gid=1871310
>>>> 3. Excel tutorials at http://www.excel-macros.blogspot.com
>>>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel
>>>> Tips
>>
>>>> and Tricks at http://exceldailytip.blogspot.com
>>>>
>>>> To post to this group, send email to excel-macros@googlegroups.com
>>>>
>>>> <><><><><><><><><><><><><><><><><><><><><><>
>>>> Like our page on facebook , Just follow below link
>>>> http://www.facebook.com/discussexcel
>>>>
>>>
>>>
>>> --
>>> Thanks & Regards,
>>>
>>> DILIP KUMAR PANDEY, mvp
>>> MBA,B.Com(Hons),BCA
>>> Mobile: +91 9810929744
>>> dilipan...@gmail.com
>>> dilipan...@yahoo.com
>>> New Delhi - 62, India
>>>
>>
>>
>> --
>> Thanks & Regards,
>>
>> DILIP KUMAR PANDEY, mvp
>> MBA,B.Com(Hons),BCA
>> Mobile: +91 9810929744
>> dilipan...@gmail.com
>> dilipan...@yahoo.com
>> New Delhi - 62, India
>>
>
>
> --
> Thanks & Regards,
>
> DILIP KUMAR PANDEY, mvp
> MBA,B.Com(Hons),BCA
> Mobile: +91 9810929744
> dilipan...@gmail.com
> dilipan...@yahoo.com
> New Delhi - 62, India
>
--
Thanks & Regards,
DILIP KUMAR PANDEY, mvp
MBA,B.Com(Hons),BCA
Mobile: +91 9810929744
dilipan...@gmail.com
dilipan...@yahoo.com
New Delhi - 62, India
--
----------------------------------------------------------------------------------
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
To post to this group, send email to excel-macros@googlegroups.com
<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel
