Search found 116 matches

by Princy557
Tue Sep 29, 2020 8:21 pm
Forum: PlanMaker 2021 for Windows
Topic: open worksheets of unknown count in same workbook
Replies: 5
Views: 2310

Re: open worksheets of unknown count in same workbook

Well I've pratted about for quite a few hours but up to now have not managed to so what I want. If someone has the time to spend 10 minutes or what you can spare to tell how to do it please. I have done nothing more that confuse myself with all this modern referencing and linking to other worksheets...
by Princy557
Tue Sep 29, 2020 8:11 pm
Forum: TextMaker 2021 for Windows
Topic: Graphics on labels???
Replies: 7
Views: 2774

Graphics on labels???

HI,
Just wondering if the above function actually got added as I can't see it in the help files.

The ability to include an image or graphic on labels, then apply a database to the print run?

Anyone have the answer to that please?
by Princy557
Mon Sep 14, 2020 4:37 pm
Forum: PlanMaker 2021 for Windows
Topic: Dropdown list from another workbook
Replies: 4
Views: 3053

Re: Dropdown list from another workbook

Hi
Well thanks for that, in some way your suggested method may be easier than actually having the ability to reference a different workbook. I will give it a try shortly and see how it goes.
Regards
by Princy557
Mon Sep 14, 2020 1:10 pm
Forum: PlanMaker 2021 for Windows
Topic: Dropdown list from another workbook
Replies: 4
Views: 3053

Re: Dropdown list from another workbook

Thanks for the reply. Do you know if it something on the development list for future? I have a supplier list which is common to three workbooks , so I assume I will have to 'update' three lists on three workbooks every-time there is a new supplier added? Unless there is a way that I can do it anothe...
by Princy557
Mon Sep 14, 2020 12:21 am
Forum: PlanMaker 2021 for Windows
Topic: Dropdown list from another workbook
Replies: 4
Views: 3053

Dropdown list from another workbook

Hi,
Using Input validation ...
is it possible to create a drop-down list on a worksheet in workbook A using information from workbook B?
I've been trying but I can't manage it using the standard procedure I would in the same workbook.
Regards
by Princy557
Sun Sep 06, 2020 12:29 pm
Forum: PlanMaker 2018 for Windows
Topic: worksheet action from a link activation?
Replies: 6
Views: 5662

Re: worksheet action from a link activation?

Supertech,
thanks for that, I'll follow my other line of enquiry and use the BasicMaker idea.
Might take a while, but lockdown being what it is :(
by Princy557
Sat Sep 05, 2020 8:53 pm
Forum: PlanMaker 2018 for Windows
Topic: Activate script via a button - is it going to happen?
Replies: 8
Views: 9368

Re: Activate script via a button - is it going to happen?

Supertech
Thanks for that

Should I be able to write a piece of BAS code that will insert a time and a date into the workbook. AND also open a workbook specified by the cell?
by Princy557
Sat Sep 05, 2020 8:36 pm
Forum: PlanMaker 2018 for Windows
Topic: worksheet action from a link activation?
Replies: 6
Views: 5662

Re: worksheet action from a link activation?

Hi rather than make it too complex with all my files I've knocked up a quick three file text as attached in a zip.
Hope it makes sense
Using the MyMainWorksheet as the main entry workbook.
by Princy557
Sat Sep 05, 2020 6:35 pm
Forum: PlanMaker 2018 for Windows
Topic: worksheet action from a link activation?
Replies: 6
Views: 5662

Re: worksheet action from a link activation?

Hi Supertech Think I may have mis asked the question. the links are in B2:B50 however the dates are in D2:D20 So I would be changing only data in the D range but pressing the B range. Hope that makes sense.. I have a feeling I will have to some how write some code, but no idea how I would use it on ...
by Princy557
Sat Sep 05, 2020 11:28 am
Forum: PlanMaker 2018 for Windows
Topic: worksheet action from a link activation?
Replies: 6
Views: 5662

worksheet action from a link activation?

HI,
I have a main sheet of subjects all of which are links to other workbooks. On the same page I have to enter the date last visited.
Is it possible to click on a link and the software update a field with today's date and time. Without code?
by Princy557
Sat Sep 05, 2020 11:24 am
Forum: PlanMaker 2018 for Windows
Topic: Activate script via a button - is it going to happen?
Replies: 8
Views: 9368

Re: Activate script via a button - is it going to happen?

Hi Jcrey,
Sorry, but I got distracted on to a couple of other projects. So as yet I have no information. If I get any I'll put it here.
I'm just about to put another similar question on the group.
regards
by Princy557
Wed Aug 19, 2020 10:11 pm
Forum: PlanMaker 2021 for Windows
Topic: open worksheets of unknown count in same workbook
Replies: 5
Views: 2310

Re: open worksheets of unknown count in same workbook

Thanks Martin-k
Will feedback later, sorry but probably with a follow up question.
by Princy557
Tue Aug 18, 2020 9:40 pm
Forum: PlanMaker 2021 for Windows
Topic: open worksheets of unknown count in same workbook
Replies: 5
Views: 2310

Re: open worksheets of unknown count in same workbook

HI Supertech,

Thanks, however I had hoped for a few more hints on the subject.
But never mind, thanks for responding
by Princy557
Tue Aug 18, 2020 11:59 am
Forum: PlanMaker 2021 for Windows
Topic: open worksheets of unknown count in same workbook
Replies: 5
Views: 2310

open worksheets of unknown count in same workbook

HI, How would I manage to open a list of x number of worksheets all in the same workbook, access a couple of fields and add them to a summary field on a new workbook. The worksheets are going to be fixed format titles, such as Invoice 20200811-01, Invoice 20200812-02 How do I work out how many there...
by Princy557
Wed Feb 05, 2020 4:37 am
Forum: PlanMaker 2018 for Windows
Topic: circular reference error
Replies: 2
Views: 2747

Re: circular reference error

Thanks Miguel
Sorry for the delay, been ill again. 'Old age does not come alone'
Sorted now.

Regards

Go to advanced search